Dataset info
| Number of variables | 81 |
|---|---|
| Number of observations | 5499 |
| Missing cells | 57440 (12.9%) |
| Duplicate rows | 0 (0.0%) |
| Total size in memory | 3.4 MiB |
| Average record size in memory | 648.0 B |
Variables types
| Numeric | 10 |
|---|---|
| Categorical | 38 |
| Boolean | 17 |
| Date | 0 |
| URL | 0 |
| Text (Unique) | 0 |
| Rejected | 16 |
| Unsupported | 0 |
Warnings
AdvanceAmount has constant value "0.0" | Rejected |
AdvanceReject(Y/N) has 368 (6.7%) missing values | Missing |
AmountClaim has 339 (6.2%) zeros | Zeros |
AOEmailAddress has a high cardinality: 324 distinct values | Warning |
AOEmailAddress has 377 (6.9%) missing values | Missing |
AwaitingStatus has constant value "nan" | Rejected |
CancelledDate has 5489 (99.8%) missing values | Missing |
Changes_Needed_(Y/N) has 4555 (82.8%) missing values | Missing |
Comments has a high cardinality: 348 distinct values | Warning |
Comments has 4557 (82.9%) missing values | Missing |
ConstructiveTravelFlag has 368 (6.7%) missing values | Missing |
Corrected_Date has a high cardinality: 74 distinct values | Warning |
Corrected_Date has 5375 (97.7%) missing values | Missing |
CurrentVersionCompletedDate has a high cardinality: 297 distinct values | Warning |
DateofCurrentStatus has a high cardinality: 303 distinct values | Warning |
DCSSuborganization has 3511 (63.8%) missing values | Missing |
DepartureDate has a high cardinality: 462 distinct values | Warning |
DocumentCreateDate has a high cardinality: 382 distinct values | Warning |
DocumentName has a high cardinality: 5013 distinct values | Warning |
DTAIDEmailAddress has 368 (6.7%) missing values | Missing |
Error_Category has constant value "nan" | Rejected |
ExpensesbyLOA has 433 (7.9%) zeros | Zeros |
FullName has a high cardinality: 1154 distinct values | Warning |
ImproperPaymentCorrections is highly skewed (γ1 = 65.72940543) | Skewed |
ImproperPaymentCorrections has 5290 (96.2%) zeros | Zeros |
IncludesSPP(Y/N) has constant value "N" | Rejected |
LastAOApprovedDate has a high cardinality: 297 distinct values | Warning |
LOA10by20 has a high cardinality: 548 distinct values | Warning |
LOALabel has a high cardinality: 547 distinct values | Warning |
Location/Destination(firstonly) has a high cardinality: 498 distinct values | Warning |
Location/Destination(firstonly) has 529 (9.6%) missing values | Missing |
Month_Rank is highly correlated with df_index (ρ = 0.9899008813) | Rejected |
Overpayments(Debts)* is highly skewed (γ1 = 22.12386129) | Skewed |
Overpayments(Debts)* has 5332 (97.0%) zeros | Zeros |
Overpayments_(Debts)* is highly correlated with Overpayments(Debts)* (ρ = 1) | Rejected |
PNRRecordLocator(allshown) has a high cardinality: 3267 distinct values | Warning |
PNRRecordLocator(allshown) has 1729 (31.4%) missing values | Missing |
Reference has a high cardinality: 111 distinct values | Warning |
Reference has 5222 (95.0%) missing values | Missing |
ReturnDate has a high cardinality: 467 distinct values | Warning |
ReviewedVouchers is highly correlated with Reviewed_Record (ρ = 1) | Rejected |
SDN(representativeSDNfordoctype) has a high cardinality: 4942 distinct values | Warning |
Sent_Date has 5283 (96.1%) missing values | Missing |
SignedDate has a high cardinality: 355 distinct values | Warning |
SpecialCircumstancesTripType has constant value "nan" | Rejected |
SPPReject(Y/N) has 368 (6.7%) missing values | Missing |
SSN has a high cardinality: 1077 distinct values | Warning |
SSN has 368 (6.7%) missing values | Missing |
TANum has a high cardinality: 4887 distinct values | Warning |
TotalCP-C/CR-CAmount is highly skewed (γ1 = 70.0678505) | Skewed |
TotalCP-C/CR-CAmount has 5478 (99.6%) zeros | Zeros |
TotalCP/CRAmount has 2891 (52.6%) zeros | Zeros |
TotalInputError is highly correlated with InputError (ρ = 1) | Rejected |
TotalMiscellaneous is highly correlated with Miscellaneous (ρ = 1) | Rejected |
TotalMissingInvalidReceiptDocumentation is highly correlated with Missing_InvalidReceipt_Documentation (ρ = 1) | Rejected |
TotalReceiptDoesNotMatchClaim is highly correlated with Receiptdoesnotmatchclaim (ρ = 1) | Rejected |
TotalRegulationUnauthorized is highly correlated with Regulation_Unauthorized (ρ = 1) | Rejected |
TotalReimbursableExpenses is highly correlated with AmountClaim (ρ = 0.9993386598) | Rejected |
TotalTripExpenses is highly correlated with TotalReimbursableExpenses (ρ = 0.9988470133) | Rejected |
Travel_Location has a high cardinality: 498 distinct values | Warning |
Travel_Location has 529 (9.6%) missing values | Missing |
TravelerEmailAddress has a high cardinality: 1152 distinct values | Warning |
TravelerEmailAddress has 368 (6.7%) missing values | Missing |
TravelerFirstName has a high cardinality: 616 distinct values | Warning |
TravelerLastName has a high cardinality: 1005 distinct values | Warning |
TripDescription has a high cardinality: 3510 distinct values | Warning |
TripDescription has 1194 (21.7%) missing values | Missing |
TripPurpose has 166 (3.0%) missing values | Missing |
TripType has 166 (3.0%) missing values | Missing |
Underpayments(Credits)* is highly skewed (γ1 = 51.72512377) | Skewed |
Underpayments(Credits)* has 5428 (98.7%) zeros | Zeros |
Underpayments_(Credits)* is highly correlated with Underpayments(Credits)* (ρ = 1) | Rejected |
Actuals(Y/N)
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| N | |
|---|---|
| Y | 644 |
| Value | Count | Frequency (%) | |
| N | 4855 | 88.3% | |
| Y | 644 | 11.7% |
AdvanceAmount
Constant
This variable is constant and should be ignored for analysis
| Constant value | 0.0 |
|---|
AdvanceReject(Y/N)
Categorical
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 6.7% |
| Missing (n) | 368 |
| N | |
|---|---|
| (Missing) | 368 |
| Value | Count | Frequency (%) | |
| N | 5131 | 93.3% | |
| (Missing) | 368 | 6.7% |
| Max length | 3 |
|---|---|
| Mean length | 1.133842517 |
| Min length | 1 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | False |
| Contains non-words | False |
Advisory
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 | 109 |
| Value | Count | Frequency (%) | |
| 0 | 5390 | 98.0% | |
| 1 | 109 | 2.0% |
AmountClaim
Numeric
| Distinct count | 3591 |
|---|---|
| Unique (%) | 65.3% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 2016.091331 |
|---|---|
| Minimum | 0 |
| Maximum | 56739.73 |
| Zeros (%) | 6.2% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 255 |
| Median | 904.36 |
| Q3 | 2097.09 |
| 95-th percentile | 7696.943 |
| Maximum | 56739.73 |
| Range | 56739.73 |
| Interquartile range | 1842.09 |
Descriptive statistics
| Standard deviation | 3804.246035 |
|---|---|
| Coef of variation | 1.886941319 |
| Kurtosis | 52.56479669 |
| Mean | 2016.091331 |
| MAD | 1998.847841 |
| Skewness | 5.976357566 |
| Sum | 11086486.23 |
| Variance | 14472287.9 |
| Memory size | 43.1 KiB |
| Value | Count | Frequency (%) | |
| 0 | 339 | 6.2% | |
| 91.5 | 114 | 2.1% | |
| 307.5 | 52 | 0.9% | |
| 161.5 | 41 | 0.7% | |
| 176.5 | 38 | 0.7% | |
| 8.35 | 37 | 0.7% | |
| 157.5 | 30 | 0.5% | |
| 211.5 | 26 | 0.5% | |
| 320 | 25 | 0.5% | |
| 3.1 | 25 | 0.5% | |
| Other values (3581) | 4772 | 86.8% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 339 | 6.2% | |
| 3.1 | 25 | 0.5% | |
| 5 | 2 | < 0.1% | |
| 5.25 | 1 | < 0.1% | |
| 6.47 | 2 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 56739.73 | 1 | < 0.1% | |
| 53760.22 | 1 | < 0.1% | |
| 43908.57 | 1 | < 0.1% | |
| 43908.31 | 2 | < 0.1% | |
| 42330.84 | 3 | 0.1% |
AOEmailAddress
Categorical
| Distinct count | 324 |
|---|---|
| Unique (%) | 5.9% |
| Missing (%) | 6.9% |
| Missing (n) | 377 |
| MICHAEL.J.MCGONAGLE2.CIV@MAIL.MIL | 634 |
|---|---|
| jason.focht@us.af.mil | 260 |
| darrell.l.williams58.civ@mail.mil | 192 |
| Other values (320) | |
| (Missing) | 377 |
| Value | Count | Frequency (%) | |
| MICHAEL.J.MCGONAGLE2.CIV@MAIL.MIL | 634 | 11.5% | |
| jason.focht@us.af.mil | 260 | 4.7% | |
| darrell.l.williams58.civ@mail.mil | 192 | 3.5% | |
| john.l.huff8.mil@mail.mil | 149 | 2.7% | |
| michael.a.hansen12.civ@mail.mil | 122 | 2.2% | |
| Vincent.Cassano@me.navy.mil | 109 | 2.0% | |
| john.a.syc.civ@mail.mil | 98 | 1.8% | |
| omar.correa@airtermnorva.navy.mil | 96 | 1.7% | |
| LASHON.R.RUSSELL@NAVY.MIL | 95 | 1.7% | |
| brian.j.muller.civ@mail.mil | 91 | 1.7% | |
| Other values (313) | 3276 | 59.6% | |
| (Missing) | 377 | 6.9% |
| Max length | 39 |
|---|---|
| Mean length | 26.17966903 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | True |
AutoKey
Numeric
| Distinct count | 5499 |
|---|---|
| Unique (%) | 100.0% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 65519.00182 |
|---|---|
| Minimum | 58303 |
| Maximum | 69795 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 58303 |
|---|---|
| 5-th percentile | 62778.9 |
| Q1 | 63878.5 |
| Median | 65253 |
| Q3 | 66627.5 |
| 95-th percentile | 68831.1 |
| Maximum | 69795 |
| Range | 11492 |
| Interquartile range | 2749 |
Descriptive statistics
| Standard deviation | 2006.940967 |
|---|---|
| Coef of variation | 0.0306314338 |
| Kurtosis | -0.792993044 |
| Mean | 65519.00182 |
| MAD | 1667.956168 |
| Skewness | 0.3715240928 |
| Sum | 360288991 |
| Variance | 4027812.045 |
| Memory size | 43.1 KiB |
| Value | Count | Frequency (%) | |
| 65031 | 1 | < 0.1% | |
| 67928 | 1 | < 0.1% | |
| 67874 | 1 | < 0.1% | |
| 65805 | 1 | < 0.1% | |
| 65919 | 1 | < 0.1% | |
| 67927 | 1 | < 0.1% | |
| 65148 | 1 | < 0.1% | |
| 66026 | 1 | < 0.1% | |
| 64110 | 1 | < 0.1% | |
| 65511 | 1 | < 0.1% | |
| Other values (5489) | 5489 | 99.8% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 58303 | 1 | < 0.1% | |
| 58852 | 1 | < 0.1% | |
| 58853 | 1 | < 0.1% | |
| 58854 | 1 | < 0.1% | |
| 58938 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 69795 | 1 | < 0.1% | |
| 69794 | 1 | < 0.1% | |
| 69793 | 1 | < 0.1% | |
| 69792 | 1 | < 0.1% | |
| 69791 | 1 | < 0.1% |
AwaitingStatus
Constant
This variable is constant and should be ignored for analysis
| Constant value | nan |
|---|
CancelledDate
Categorical
| Distinct count | 11 |
|---|---|
| Unique (%) | 0.2% |
| Missing (%) | 99.8% |
| Missing (n) | 5489 |
| 43619 | 1 |
|---|---|
| 8/13/2019 | 1 |
| 2/10/2020 | 1 |
| Other values (7) | 7 |
| (Missing) |
| Value | Count | Frequency (%) | |
| 43619 | 1 | < 0.1% | |
| 8/13/2019 | 1 | < 0.1% | |
| 2/10/2020 | 1 | < 0.1% | |
| 11/18/2019 | 1 | < 0.1% | |
| 9/13/2019 | 1 | < 0.1% | |
| 7/22/2019 | 1 | < 0.1% | |
| 7/24/2019 | 1 | < 0.1% | |
| 8/15/2019 | 1 | < 0.1% | |
| 3/24/2020 | 1 | < 0.1% | |
| 1/10/2020 | 1 | < 0.1% | |
| (Missing) | 5489 | 99.8% |
| Max length | 10 |
|---|---|
| Mean length | 3.010365521 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | True |
Changes_Needed_(Y/N)
Boolean
| Distinct count | 3 |
|---|---|
| Unique (%) | 0.1% |
| Missing (%) | 82.8% |
| Missing (n) | 4555 |
| No | 725 |
|---|---|
| Yes | 219 |
| (Missing) |
| Value | Count | Frequency (%) | |
| No | 725 | 13.2% | |
| Yes | 219 | 4.0% | |
| (Missing) | 4555 | 82.8% |
Comments
Categorical
| Distinct count | 348 |
|---|---|
| Unique (%) | 6.3% |
| Missing (%) | 82.9% |
| Missing (n) | 4557 |
| Okay | 584 |
|---|---|
| This voucher being audited as it overlaps with TANUM 28IXFD, changed Month-End Date from 5-31-2019 so it will print on the July PPR report. Because this is a TDY from a TDY location the first and last day of this is considered interim travel days and should be paid at full M&IE rate not as 75% travel day. Traveler due additional $28. Per JTR 020303 Table 2-16, Lodging claim for this TDY should be claimed on the per diem screen, lodging retained at the original TDY location is claimed under expenses as Dual Lodging. Unable to correct errors as traveler is no longer assigned to USTRANSCOM. TSgt Patrick Weaver - 20191018 | 3 |
| Advisory: This voucher was T-entered by Kayla Georgiafandis. The DD 1351-2 attached was printed from DTS after the voucher was created. If the NDEA creates the voucher without being given a signed DD 1351-2 telling them what to claim on the voucher, the Traveler needs to review the voucher and personnally sign it using their CAC. In order for an NDEA to use T-enter (sign the voucher) capability the following rules MUST be followed: According to the DoD Financial Management Regulation, the requirements for a valid 1351-2 are: The traveler must manually prepare it. The traveler must either print the voucher and fill in the information (pen and ink) or make entries on an electronic version of the form (e.g., .pdf form). Printing the form from DTS is NOT considered a valid version. The traveler must sign it. Ink or a valid electronic signature (e.g., CAC verification) is sufficient. (All entries must be complete.) The NDEA must electronically attach it to the DTS voucher. On the Expenses screen in the Substantiating Documents section. It is not legal to submit a voucher for another traveler without their signature. We will be doing a 100% review of all T-entered vouchers going forward along with the normal Post Payment Reviews. Any NDEA found to not be following the proper procedures will have the capability removed. The procedures outlined above and in the NDEA training keeps the NDEA from any pecuniary liability for an improper payment. | 2 |
| Other values (344) | 353 |
| (Missing) |
| Value | Count | Frequency (%) | |
| Okay | 584 | 10.6% | |
| This voucher being audited as it overlaps with TANUM 28IXFD, changed Month-End Date from 5-31-2019 so it will print on the July PPR report. Because this is a TDY from a TDY location the first and last day of this is considered interim travel days and should be paid at full M&IE rate not as 75% travel day. Traveler due additional $28. Per JTR 020303 Table 2-16, Lodging claim for this TDY should be claimed on the per diem screen, lodging retained at the original TDY location is claimed under expenses as Dual Lodging. Unable to correct errors as traveler is no longer assigned to USTRANSCOM. TSgt Patrick Weaver - 20191018 | 3 | 0.1% | |
| Advisory: This voucher was T-entered by Kayla Georgiafandis. The DD 1351-2 attached was printed from DTS after the voucher was created. If the NDEA creates the voucher without being given a signed DD 1351-2 telling them what to claim on the voucher, the Traveler needs to review the voucher and personnally sign it using their CAC. In order for an NDEA to use T-enter (sign the voucher) capability the following rules MUST be followed: According to the DoD Financial Management Regulation, the requirements for a valid 1351-2 are: The traveler must manually prepare it. The traveler must either print the voucher and fill in the information (pen and ink) or make entries on an electronic version of the form (e.g., .pdf form). Printing the form from DTS is NOT considered a valid version. The traveler must sign it. Ink or a valid electronic signature (e.g., CAC verification) is sufficient. (All entries must be complete.) The NDEA must electronically attach it to the DTS voucher. On the Expenses screen in the Substantiating Documents section. It is not legal to submit a voucher for another traveler without their signature. We will be doing a 100% review of all T-entered vouchers going forward along with the normal Post Payment Reviews. Any NDEA found to not be following the proper procedures will have the capability removed. The procedures outlined above and in the NDEA training keeps the NDEA from any pecuniary liability for an improper payment. | 2 | < 0.1% | |
| Advisory: According to the DoD Financial Management Regulation, the requirements for a valid 1351-2 are: The traveler must manually prepare it prior to it being completed in DTS. The traveler must either print the voucher and fill in the information (pen and ink) or make entries on an electronic version of the form (e.g., .pdf form). Printing the form from DTS is NOT considered a valid version. The traveler must sign it. Ink or a valid electronic signature (e.g., CAC verification) is sufficient. (All entries must be complete.) This was improperly T-entered by Marrisa Myatt. This is the 3rd month she was found to not be following the Dod FMR Regulations. | 2 | < 0.1% | |
| This voucher was T-entered by Giselle Murrell. There is no DD 1351-2 submitted by and signed by the traveler attached. Before a Non-DTS Entry Agent (NDEA) can T-ENTER a voucher, the traveler must provide the NDEA with a signed, manually-prepared DD Form 1351-2 telling them what expenses to claim on the voucher. According to the DoD Financial Management Regulation, the requirements for a valid 1351-2 are: The traveler must manually prepare it. The traveler must either print the voucher and fill in the information (pen and ink) or make entries on an electronic version of the form (e.g., .pdf form). Printing the form from DTS is NOT considered a valid version. The traveler must sign it. Ink or a valid electronic signature (e.g., CAC verification) is sufficient. (All entries must be complete.) The NDEA must electronically attach it to the DTS voucher. On the Expenses screen in the Substantiating Documents section. It is not legal to submit a voucher for another traveler without their signature. We will be doing a 100% review of all T-entered vouchers going forward along with the normal Post Payment Reviews. Any NDEA found to not be following the proper procedures will have the T-enter capability removed. The procedures outlined above, and in the NDEA training, keep the NDEA from any pecuniary liability for an improper payment. Please have traveler provide a completed and signed DD 1351-2 and attach it. | 2 | < 0.1% | |
| Advisory: Traveler was charged $100 for lodging on the day of arrival but only claimed $90 may be due additional $10 if they choose to amend. | 2 | < 0.1% | |
| Okay - 12 hrs or less | 2 | < 0.1% | |
| Advisory: Laundry is covered by the daily incidental paid the traveler and is not a reimbursable item. No change required as it is under $10 and would be written off. | 2 | < 0.1% | |
| Advisory: Per DoD FMR vol 9 Ch 8 080401G -To receive proper reimbursement, the traveler must report the following information on their travel claim: The amount of the expense in foreign currency; the exchange rate on the day the item was purchased in cash, or, the exchange rate at which the credit card was billed if paid with a credit card; and the bank commission(s) charged for conversion of U.S. dollars to foreign currency. The traveler must show the rates of conversion and the commission(s) charged. If the traveler does not show the conversion rate(s), the activity settling the claim must use an appropriate exchange rate for the date the expense was paid | 2 | < 0.1% | |
| Advisory: Was traveler's business conducted in Belleville or at Scott AFB? If Scott AFB that should have been the TDY location used, which would require a Non-A to stay off base. Without a Non-A traveler should have been limited to the $105 rate for lodging on base. | 2 | < 0.1% | |
| Other values (337) | 339 | 6.2% | |
| (Missing) | 4557 | 82.9% |
| Max length | 3409 |
|---|---|
| Mean length | 36.08346972 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
ConstructiveTravelFlag
Boolean
| Distinct count | 3 |
|---|---|
| Unique (%) | 0.1% |
| Missing (%) | 6.7% |
| Missing (n) | 368 |
| N | |
|---|---|
| Y | 42 |
| (Missing) | 368 |
| Value | Count | Frequency (%) | |
| N | 5089 | 92.5% | |
| Y | 42 | 0.8% | |
| (Missing) | 368 | 6.7% |
Corrected_Date
Categorical
| Distinct count | 74 |
|---|---|
| Unique (%) | 1.3% |
| Missing (%) | 97.7% |
| Missing (n) | 5375 |
| 10/18/19 | 20 |
|---|---|
| 11/4/19 | 5 |
| 4/27/20 | 4 |
| Other values (70) | 95 |
| (Missing) |
| Value | Count | Frequency (%) | |
| 10/18/19 | 20 | 0.4% | |
| 11/4/19 | 5 | 0.1% | |
| 4/27/20 | 4 | 0.1% | |
| 3/13/20 | 3 | 0.1% | |
| 3/11/20 | 3 | 0.1% | |
| 12/10/19 | 3 | 0.1% | |
| 1/22/20 | 3 | 0.1% | |
| 4/20/20 | 3 | 0.1% | |
| 9/18/19 | 3 | 0.1% | |
| 8/16/19 | 2 | < 0.1% | |
| Other values (63) | 75 | 1.4% | |
| (Missing) | 5375 | 97.7% |
| Max length | 8 |
|---|---|
| Mean length | 3.093289689 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | True |
CorrectedVouchers
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 | 123 |
| Value | Count | Frequency (%) | |
| 0 | 5376 | 97.8% | |
| 1 | 123 | 2.2% |
CurrentStatus
Categorical
| Distinct count | 19 |
|---|---|
| Unique (%) | 0.3% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| ARCHIVE IMAGE ACCEPT | |
|---|---|
| ARCHIVE ACCEPTED | |
| OBLIG SUBMITTED | 260 |
| Other values (16) |
| Value | Count | Frequency (%) | |
| ARCHIVE IMAGE ACCEPT | 2256 | 41.0% | |
| ARCHIVE ACCEPTED | 2208 | 40.2% | |
| OBLIG SUBMITTED | 260 | 4.7% | |
| POS ACK RECEIVED | 234 | 4.3% | |
| VOUCHER SUBMITTED | 211 | 3.8% | |
| ARCHIVE SUBMITTED | 127 | 2.3% | |
| REJECT | 54 | 1.0% | |
| DUE PROCESS SERVED | 44 | 0.8% | |
| ARCHIVE IMAGE SUBMIT | 33 | 0.6% | |
| PAID | 22 | 0.4% | |
| Other values (9) | 50 | 0.9% |
| Max length | 20 |
|---|---|
| Mean length | 17.54373522 |
| Min length | 4 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
CurrentVersionCompletedDate
Categorical
| Distinct count | 297 |
|---|---|
| Unique (%) | 5.4% |
| Missing (%) | 0.2% |
| Missing (n) | 10 |
| 12/2/19 | 83 |
|---|---|
| 7/3/19 | 62 |
| 2/10/20 | 55 |
| Other values (293) |
| Value | Count | Frequency (%) | |
| 12/2/19 | 83 | 1.5% | |
| 7/3/19 | 62 | 1.1% | |
| 2/10/20 | 55 | 1.0% | |
| 12/4/19 | 53 | 1.0% | |
| 7/22/19 | 45 | 0.8% | |
| 9/23/19 | 45 | 0.8% | |
| 12/18/19 | 45 | 0.8% | |
| 12/3/19 | 45 | 0.8% | |
| 2/3/20 | 44 | 0.8% | |
| 9/16/19 | 43 | 0.8% | |
| Other values (286) | 4969 | 90.4% |
| Max length | 8 |
|---|---|
| Mean length | 6.98108747 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | True |
DateofCurrentStatus
Categorical
| Distinct count | 303 |
|---|---|
| Unique (%) | 5.5% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 12/31/19 | 102 |
|---|---|
| 12/28/19 | 100 |
| 12/30/19 | 99 |
| Other values (300) |
| Value | Count | Frequency (%) | |
| 12/31/19 | 102 | 1.9% | |
| 12/28/19 | 100 | 1.8% | |
| 12/30/19 | 99 | 1.8% | |
| 12/29/19 | 92 | 1.7% | |
| 2/20/20 | 86 | 1.6% | |
| 2/22/20 | 81 | 1.5% | |
| 11/27/19 | 78 | 1.4% | |
| 1/1/20 | 73 | 1.3% | |
| 10/9/19 | 69 | 1.3% | |
| 10/12/19 | 67 | 1.2% | |
| Other values (293) | 4652 | 84.6% |
| Max length | 8 |
|---|---|
| Mean length | 7.054737225 |
| Min length | 6 |
| Contains chars | False |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | True |
DCSSuborganization
Categorical
| Distinct count | 19 |
|---|---|
| Unique (%) | 0.3% |
| Missing (%) | 63.8% |
| Missing (n) | 3511 |
| BA | 364 |
|---|---|
| RS | 251 |
| SG | 175 |
| Other values (15) | |
| (Missing) |
| Value | Count | Frequency (%) | |
| BA | 364 | 6.6% | |
| RS | 251 | 4.6% | |
| SG | 175 | 3.2% | |
| BH | 160 | 2.9% | |
| JA | 157 | 2.9% | |
| LV | 131 | 2.4% | |
| NF | 123 | 2.2% | |
| TV | 119 | 2.2% | |
| SN | 98 | 1.8% | |
| YO | 75 | 1.4% | |
| Other values (8) | 335 | 6.1% | |
| (Missing) | 3511 | 63.8% |
| Max length | 3 |
|---|---|
| Mean length | 2.638479724 |
| Min length | 2 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | False |
| Contains non-words | False |
DepartureDate
Categorical
| Distinct count | 462 |
|---|---|
| Unique (%) | 8.4% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 9/16/19 | 59 |
|---|---|
| 10/1/19 | 59 |
| 12/9/19 | 57 |
| Other values (459) |
| Value | Count | Frequency (%) | |
| 9/16/19 | 59 | 1.1% | |
| 10/1/19 | 59 | 1.1% | |
| 12/9/19 | 57 | 1.0% | |
| 2/24/20 | 51 | 0.9% | |
| 11/12/19 | 51 | 0.9% | |
| 5/28/19 | 49 | 0.9% | |
| 2/10/20 | 47 | 0.9% | |
| 9/22/19 | 46 | 0.8% | |
| 10/7/19 | 46 | 0.8% | |
| 8/12/19 | 46 | 0.8% | |
| Other values (452) | 4988 | 90.7% |
| Max length | 8 |
|---|---|
| Mean length | 6.939443535 |
| Min length | 6 |
| Contains chars | False |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | True |
df_index
Numeric
| Distinct count | 5499 |
|---|---|
| Unique (%) | 100.0% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 3451.171849 |
|---|---|
| Minimum | 0 |
| Maximum | 7132 |
| Zeros (%) | < 0.1% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 377.9 |
| Q1 | 1650.5 |
| Median | 3352 |
| Q3 | 5241.5 |
| 95-th percentile | 6741.1 |
| Maximum | 7132 |
| Range | 7132 |
| Interquartile range | 3591 |
Descriptive statistics
| Standard deviation | 2062.893212 |
|---|---|
| Coef of variation | 0.5977370302 |
| Kurtosis | -1.219564481 |
| Mean | 3451.171849 |
| MAD | 1794.976145 |
| Skewness | 0.1018863934 |
| Sum | 18977994 |
| Variance | 4255528.404 |
| Memory size | 43.1 KiB |
| Value | Count | Frequency (%) | |
| 2047 | 1 | < 0.1% | |
| 4691 | 1 | < 0.1% | |
| 2632 | 1 | < 0.1% | |
| 585 | 1 | < 0.1% | |
| 6730 | 1 | < 0.1% | |
| 2636 | 1 | < 0.1% | |
| 6734 | 1 | < 0.1% | |
| 2640 | 1 | < 0.1% | |
| 593 | 1 | < 0.1% | |
| 6738 | 1 | < 0.1% | |
| Other values (5489) | 5489 | 99.8% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 1 | < 0.1% | |
| 2 | 1 | < 0.1% | |
| 3 | 1 | < 0.1% | |
| 4 | 1 | < 0.1% | |
| 5 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 7132 | 1 | < 0.1% | |
| 7131 | 1 | < 0.1% | |
| 7130 | 1 | < 0.1% | |
| 7129 | 1 | < 0.1% | |
| 7128 | 1 | < 0.1% |
Directorate
Categorical
| Distinct count | 14 |
|---|---|
| Unique (%) | 0.3% |
| Missing (%) | 0.1% |
| Missing (n) | 4 |
| TCJ3DCS | |
|---|---|
| JECC | |
| TCJ3 | |
| Other values (10) |
| Value | Count | Frequency (%) | |
| TCJ3DCS | 1988 | 36.2% | |
| JECC | 1238 | 22.5% | |
| TCJ3 | 576 | 10.5% | |
| TCJ5 | 533 | 9.7% | |
| TCCC | 399 | 7.3% | |
| TCSG | 162 | 2.9% | |
| TCAQ | 145 | 2.6% | |
| TCJ6 | 141 | 2.6% | |
| TCJ8 | 139 | 2.5% | |
| TCJ1 | 84 | 1.5% | |
| Other values (3) | 90 | 1.6% |
| Max length | 7 |
|---|---|
| Mean length | 5.083833424 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | False |
DocumentCreateDate
Categorical
| Distinct count | 382 |
|---|---|
| Unique (%) | 6.9% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 11/25/19 | 62 |
|---|---|
| 2/3/20 | 54 |
| 3/9/20 | 54 |
| Other values (379) |
| Value | Count | Frequency (%) | |
| 11/25/19 | 62 | 1.1% | |
| 2/3/20 | 54 | 1.0% | |
| 3/9/20 | 54 | 1.0% | |
| 9/30/19 | 53 | 1.0% | |
| 12/18/19 | 52 | 0.9% | |
| 3/2/20 | 47 | 0.9% | |
| 1/21/20 | 46 | 0.8% | |
| 9/16/19 | 45 | 0.8% | |
| 11/26/19 | 45 | 0.8% | |
| 11/22/19 | 43 | 0.8% | |
| Other values (372) | 4998 | 90.9% |
| Max length | 8 |
|---|---|
| Mean length | 6.999818149 |
| Min length | 6 |
| Contains chars | False |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | True |
DocumentName
Categorical
| Distinct count | 5013 |
|---|---|
| Unique (%) | 91.2% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| SLPOPEARMYAIR081619_V01 | 6 |
|---|---|
| SLSTUTTGARTDE111219_V01 | 6 |
| SLROBINSAFBGA080819_V01 | 6 |
| Other values (5010) |
| Value | Count | Frequency (%) | |
| SLPOPEARMYAIR081619_V01 | 6 | 0.1% | |
| SLSTUTTGARTDE111219_V01 | 6 | 0.1% | |
| SLROBINSAFBGA080819_V01 | 6 | 0.1% | |
| SLWASHINGTOND031120_V01 | 5 | 0.1% | |
| ESNORFOLKVA091519_V03 | 5 | 0.1% | |
| SLSHAWAFBSC082219_V01 | 5 | 0.1% | |
| SLFAIRCHILDAF092419_V01 | 5 | 0.1% | |
| SLNORFOLKNAVA012120_V01 | 5 | 0.1% | |
| SLWASHINGTOND071719_V01 | 5 | 0.1% | |
| SLAUSTINTX020620_V01 | 5 | 0.1% | |
| Other values (5003) | 5446 | 99.0% |
| Max length | 26 |
|---|---|
| Mean length | 22.47663211 |
| Min length | 12 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | True |
DocumentType
Categorical
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| VCH | |
|---|---|
| LVCH | 166 |
| Value | Count | Frequency (%) | |
| VCH | 5333 | 97.0% | |
| LVCH | 166 | 3.0% |
| Max length | 4 |
|---|---|
| Mean length | 3.030187307 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | False |
| Contains non-words | False |
DTAIDEmailAddress
Categorical
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 6.7% |
| Missing (n) | 368 |
| transcom.scott.tcj8.mbx.dts-rejects@mail.mil | |
|---|---|
| (Missing) | 368 |
| Value | Count | Frequency (%) | |
| transcom.scott.tcj8.mbx.dts-rejects@mail.mil | 5131 | 93.3% | |
| (Missing) | 368 | 6.7% |
| Max length | 44 |
|---|---|
| Mean length | 41.25622841 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | True |
Error_Category
Constant
This variable is constant and should be ignored for analysis
| Constant value | nan |
|---|
ExpensesbyLOA
Numeric
| Distinct count | 3766 |
|---|---|
| Unique (%) | 68.5% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 1629.298071 |
|---|---|
| Minimum | 0 |
| Maximum | 56739.73 |
| Zeros (%) | 7.9% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 225.35 |
| Median | 775.39 |
| Q3 | 1767.6 |
| 95-th percentile | 5694.408 |
| Maximum | 56739.73 |
| Range | 56739.73 |
| Interquartile range | 1542.25 |
Descriptive statistics
| Standard deviation | 3198.752153 |
|---|---|
| Coef of variation | 1.96327008 |
| Kurtosis | 80.50969153 |
| Mean | 1629.298071 |
| MAD | 1558.213834 |
| Skewness | 7.311093677 |
| Sum | 8959510.09 |
| Variance | 10232015.34 |
| Memory size | 43.1 KiB |
| Value | Count | Frequency (%) | |
| 0 | 433 | 7.9% | |
| 91.5 | 121 | 2.2% | |
| 307.5 | 51 | 0.9% | |
| 161.5 | 42 | 0.8% | |
| 176.5 | 41 | 0.7% | |
| 8.35 | 37 | 0.7% | |
| 157.5 | 29 | 0.5% | |
| 211.5 | 26 | 0.5% | |
| 3.1 | 26 | 0.5% | |
| 320 | 25 | 0.5% | |
| Other values (3756) | 4668 | 84.9% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 433 | 7.9% | |
| 3.1 | 26 | 0.5% | |
| 5 | 2 | < 0.1% | |
| 5.25 | 1 | < 0.1% | |
| 6.47 | 2 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 56739.73 | 1 | < 0.1% | |
| 53760.22 | 1 | < 0.1% | |
| 43908.31 | 2 | < 0.1% | |
| 42330.84 | 2 | < 0.1% | |
| 41483.87 | 2 | < 0.1% |
FinancialReject(Y/N)
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| N | |
|---|---|
| Y | 54 |
| Value | Count | Frequency (%) | |
| N | 5445 | 99.0% | |
| Y | 54 | 1.0% |
ForeignTravelFlag
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| N | |
|---|---|
| Y |
| Value | Count | Frequency (%) | |
| N | 3981 | 72.4% | |
| Y | 1518 | 27.6% |
FullName
Categorical
| Distinct count | 1154 |
|---|---|
| Unique (%) | 21.0% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| JAMES SHEPARD | 38 |
|---|---|
| STEPHEN LYONS | 37 |
| JOSEPH REICHERT | 32 |
| Other values (1151) |
| Value | Count | Frequency (%) | |
| JAMES SHEPARD | 38 | 0.7% | |
| STEPHEN LYONS | 37 | 0.7% | |
| JOSEPH REICHERT | 32 | 0.6% | |
| ANDREA GONZALES | 31 | 0.6% | |
| DONALD ABSHER | 31 | 0.6% | |
| SHAWN BEDARD | 29 | 0.5% | |
| TRACEY TURNER | 29 | 0.5% | |
| HORACE TAYLOR | 28 | 0.5% | |
| JASON FRANCE | 27 | 0.5% | |
| ANDREW KRUCZYK | 27 | 0.5% | |
| Other values (1144) | 5190 | 94.4% |
| Max length | 25 |
|---|---|
| Mean length | 13.67612293 |
| Min length | 8 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
ImproperPaymentCorrections
Numeric
| Distinct count | 58 |
|---|---|
| Unique (%) | 1.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 236.2027641 |
|---|---|
| Minimum | 0 |
| Maximum | 332306 |
| Zeros (%) | 96.2% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 332306 |
| Range | 332306 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 4666.375408 |
|---|---|
| Coef of variation | 19.75580356 |
| Kurtosis | 4666.80792 |
| Mean | 236.2027641 |
| MAD | 461.6530748 |
| Skewness | 65.72940543 |
| Sum | 1298879 |
| Variance | 21775059.45 |
| Memory size | 43.1 KiB |
| Value | Count | Frequency (%) | |
| 0 | 5290 | 96.2% | |
| 9999 | 96 | 1.7% | |
| 58 | 16 | 0.3% | |
| 1 | 8 | 0.1% | |
| 94 | 4 | 0.1% | |
| 7 | 4 | 0.1% | |
| 4 | 4 | 0.1% | |
| 48 | 4 | 0.1% | |
| 5 | 3 | 0.1% | |
| 162 | 3 | 0.1% | |
| Other values (48) | 67 | 1.2% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 5290 | 96.2% | |
| 1 | 8 | 0.1% | |
| 2 | 3 | 0.1% | |
| 4 | 4 | 0.1% | |
| 5 | 3 | 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 332306 | 1 | < 0.1% | |
| 9999 | 96 | 1.7% | |
| 253 | 1 | < 0.1% | |
| 200 | 1 | < 0.1% | |
| 194 | 1 | < 0.1% |
ImproperPayments
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 | 219 |
| Value | Count | Frequency (%) | |
| 0 | 5280 | 96.0% | |
| 1 | 219 | 4.0% |
IncludesSPP(Y/N)
Constant
This variable is constant and should be ignored for analysis
| Constant value | N |
|---|
InputError
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 | 43 |
| Value | Count | Frequency (%) | |
| 0 | 5456 | 99.2% | |
| 1 | 43 | 0.8% |
LastAOApprovedDate
Categorical
| Distinct count | 297 |
|---|---|
| Unique (%) | 5.4% |
| Missing (%) | 0.2% |
| Missing (n) | 10 |
| 12/2/19 | 83 |
|---|---|
| 7/3/19 | 62 |
| 2/10/20 | 55 |
| Other values (293) |
| Value | Count | Frequency (%) | |
| 12/2/19 | 83 | 1.5% | |
| 7/3/19 | 62 | 1.1% | |
| 2/10/20 | 55 | 1.0% | |
| 12/4/19 | 53 | 1.0% | |
| 7/22/19 | 45 | 0.8% | |
| 9/23/19 | 45 | 0.8% | |
| 12/18/19 | 45 | 0.8% | |
| 12/3/19 | 45 | 0.8% | |
| 2/3/20 | 44 | 0.8% | |
| 9/16/19 | 43 | 0.8% | |
| Other values (286) | 4969 | 90.4% |
| Max length | 8 |
|---|---|
| Mean length | 6.98108747 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | True |
LOA10by20
Categorical
| Distinct count | 548 |
|---|---|
| Unique (%) | 10.0% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 387700^97^^X^4930^FD60^6J^0^70^D1^G31M31^^_12400^^^^40924^^^387700^^^91222F^^^^^ | 209 |
|---|---|
| 387700^97^^X^4930^FD50^6F^0^70^AB^G00000^^_12400^^^^40924^^^387700^^^48090D^^^^^ | 202 |
| 387700^97^^X^4930^FD50^6F^9^70^AB^G00000^^_12400^^^^40924^^^387700^^^48090D^^^^^ | 172 |
| Other values (545) |
| Value | Count | Frequency (%) | |
| 387700^97^^X^4930^FD60^6J^0^70^D1^G31M31^^_12400^^^^40924^^^387700^^^91222F^^^^^ | 209 | 3.8% | |
| 387700^97^^X^4930^FD50^6F^0^70^AB^G00000^^_12400^^^^40924^^^387700^^^48090D^^^^^ | 202 | 3.7% | |
| 387700^97^^X^4930^FD50^6F^9^70^AB^G00000^^_12400^^^^40924^^^387700^^^48090D^^^^^ | 172 | 3.1% | |
| 387700^97^^X^4930^FD60^6J^9^70^D1^G31M31^^_12400^^^^40924^^^387700^^^91222F^^^^^ | 144 | 2.6% | |
| 387700^97^^X^4930^FD60^6J^0^70^FB^G31M31^^_12400^^^^40924^^^387700^^^91222F^^^^^ | 122 | 2.2% | |
| 387700^97^^X^4930^FD60^6J^9^70^FB^G31M31^^_12400^^^^40924^^^387700^^^91222F^^^^^ | 102 | 1.9% | |
| 387700^97^^X^4930^FD60^6J^0^70^FC^G31M31^^_12400^^^^40924^^^387700^^^91222F^^^^^ | 89 | 1.6% | |
| 387700^97^^X^4930^FD60^6J^0^70^D3^G31M31^^_12400^^^^40924^^^387700^^^91222F^^^^^ | 88 | 1.6% | |
| 387700^57^^9^3400^^30^9^70^JE^G3JE40^02^^^^^40924^^^387700^^^21400F^^^^^ | 85 | 1.5% | |
| 387700^97^^X^4930^FD60^6J^0^70^FA^G31M31^^_12400^^^^40924^^^387700^^^91222F^^^^^ | 81 | 1.5% | |
| Other values (538) | 4205 | 76.5% |
| Max length | 103 |
|---|---|
| Mean length | 78.5766503 |
| Min length | 64 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
LOALabel
Categorical
| Distinct count | 547 |
|---|---|
| Unique (%) | 9.9% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 20 DCS BA MSPT | 209 |
|---|---|
| 20 CMDSEC MSPT | 202 |
| 19 CMDSEC MSPT | 172 |
| Other values (544) |
| Value | Count | Frequency (%) | |
| 20 DCS BA MSPT | 209 | 3.8% | |
| 20 CMDSEC MSPT | 202 | 3.7% | |
| 19 CMDSEC MSPT | 172 | 3.1% | |
| 19 DCS BA MSPT | 144 | 2.6% | |
| 20 DCS RS MSPT | 122 | 2.2% | |
| 19 DCS RS MSPT | 102 | 1.9% | |
| 20 DCS SG MSPT | 89 | 1.6% | |
| 20 DCS JA MSPT | 88 | 1.6% | |
| 19 JR_JPSE | 85 | 1.5% | |
| 20 DCS BH MSPT | 81 | 1.5% | |
| Other values (537) | 4205 | 76.5% |
| Max length | 15 |
|---|---|
| Mean length | 12.88343335 |
| Min length | 5 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
Location/Destination(firstonly)
Categorical
| Distinct count | 498 |
|---|---|
| Unique (%) | 9.1% |
| Missing (%) | 9.6% |
| Missing (n) | 529 |
| NORFOLK NAVAL STATION,VA | 289 |
|---|---|
| WASHINGTON,DC | 228 |
| MACDILL AFB,FL | 124 |
| Other values (494) | |
| (Missing) | 529 |
| Value | Count | Frequency (%) | |
| NORFOLK NAVAL STATION,VA | 289 | 5.3% | |
| WASHINGTON,DC | 228 | 4.1% | |
| MACDILL AFB,FL | 124 | 2.3% | |
| SCOTT AFB,IL | 121 | 2.2% | |
| PENTAGON,VA | 106 | 1.9% | |
| MEMPHIS,TN | 106 | 1.9% | |
| RAMSTEIN AB,DEU | 97 | 1.8% | |
| SIGONELLA NAS,ITA | 93 | 1.7% | |
| MILITARY BASES NOT IN KUWAIT CITY,KWT | 82 | 1.5% | |
| SAN ANTONIO,TX | 79 | 1.4% | |
| Other values (487) | 3645 | 66.3% | |
| (Missing) | 529 | 9.6% |
| Max length | 47 |
|---|---|
| Mean length | 14.78868885 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
Miscellaneous
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 | 1 |
| Value | Count | Frequency (%) | |
| 0 | 5498 | > 99.9% | |
| 1 | 1 | < 0.1% |
Missing_InvalidReceipt_Documentation
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 | 91 |
| Value | Count | Frequency (%) | |
| 0 | 5408 | 98.3% | |
| 1 | 91 | 1.7% |
Month_End
Categorical
| Distinct count | 12 |
|---|---|
| Unique (%) | 0.2% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 9/30/19 | 645 |
|---|---|
| 12/31/19 | 612 |
| 8/30/19 | 586 |
| Other values (9) |
| Value | Count | Frequency (%) | |
| 9/30/19 | 645 | 11.7% | |
| 12/31/19 | 612 | 11.1% | |
| 8/30/19 | 586 | 10.7% | |
| 10/31/19 | 583 | 10.6% | |
| 2/29/20 | 555 | 10.1% | |
| 6/30/19 | 534 | 9.7% | |
| 7/31/19 | 532 | 9.7% | |
| 3/31/20 | 516 | 9.4% | |
| 11/30/19 | 380 | 6.9% | |
| 1/31/20 | 368 | 6.7% | |
| Other values (2) | 188 | 3.4% |
| Max length | 8 |
|---|---|
| Mean length | 7.286415712 |
| Min length | 7 |
| Contains chars | False |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | True |
Month_Rank
Highly correlated
This variable is highly correlated with df_index and should be ignored for analysis
| Correlation | 0.9899008813 |
|---|
MultipleLOAs(Y/N)
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| N | |
|---|---|
| Y | 673 |
| Value | Count | Frequency (%) | |
| N | 4826 | 87.8% | |
| Y | 673 | 12.2% |
Non-contractFareFlag
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| N | |
|---|---|
| Y | 382 |
| Value | Count | Frequency (%) | |
| N | 5117 | 93.1% | |
| Y | 382 | 6.9% |
Organization/Suborganization
Categorical
| Distinct count | 32 |
|---|---|
| Unique (%) | 0.6% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| DJ60TCJECC_JPSE | |
|---|---|
| DJ60TCJ5 | 533 |
| DJ60TCJ3 | 433 |
| Other values (29) |
| Value | Count | Frequency (%) | |
| DJ60TCJECC_JPSE | 918 | 16.7% | |
| DJ60TCJ5 | 533 | 9.7% | |
| DJ60TCJ3 | 433 | 7.9% | |
| DJ60TCCC | 400 | 7.3% | |
| DJ60TCJ3DCSBA | 364 | 6.6% | |
| DJ60TCJECC | 321 | 5.8% | |
| DJ60TCJ3DCSRS | 251 | 4.6% | |
| DJ60TCJ3DCSSG | 175 | 3.2% | |
| DJ60TCSG | 162 | 2.9% | |
| DJ60TCJ3DCSBH | 160 | 2.9% | |
| Other values (22) | 1782 | 32.4% |
| Max length | 15 |
|---|---|
| Mean length | 11.11929442 |
| Min length | 8 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | False |
Overpayments(Debts)*
Numeric
| Distinct count | 162 |
|---|---|
| Unique (%) | 2.9% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 17.21950173 |
|---|---|
| Minimum | 0 |
| Maximum | 6823.82 |
| Zeros (%) | 97.0% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 6823.82 |
| Range | 6823.82 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 210.0849428 |
|---|---|
| Coef of variation | 12.20040778 |
| Kurtosis | 589.6229387 |
| Mean | 17.21950173 |
| MAD | 33.4107544 |
| Skewness | 22.12386129 |
| Sum | 94690.04 |
| Variance | 44135.68318 |
| Memory size | 43.1 KiB |
| Value | Count | Frequency (%) | |
| 0 | 5332 | 97.0% | |
| 55 | 2 | < 0.1% | |
| 558 | 2 | < 0.1% | |
| 504 | 2 | < 0.1% | |
| 30.5 | 2 | < 0.1% | |
| 220.6 | 2 | < 0.1% | |
| 28 | 2 | < 0.1% | |
| 26.94 | 1 | < 0.1% | |
| 32.78 | 1 | < 0.1% | |
| 376 | 1 | < 0.1% | |
| Other values (152) | 152 | 2.8% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 5332 | 97.0% | |
| 7.61 | 1 | < 0.1% | |
| 8 | 1 | < 0.1% | |
| 8.35 | 1 | < 0.1% | |
| 11 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 6823.82 | 1 | < 0.1% | |
| 6776.5 | 1 | < 0.1% | |
| 5407.5 | 1 | < 0.1% | |
| 4564.65 | 1 | < 0.1% | |
| 4472.54 | 1 | < 0.1% |
Overpayments_(Debts)*
Highly correlated
This variable is highly correlated with Overpayments(Debts)* and should be ignored for analysis
| Correlation | 1 |
|---|
PNRRecordLocator(allshown)
Categorical
| Distinct count | 3267 |
|---|---|
| Unique (%) | 59.4% |
| Missing (%) | 31.4% |
| Missing (n) | 1729 |
| QXRTCZ | 10 |
|---|---|
| MU7XPH | 8 |
| UPOMOM | 8 |
| Other values (3263) | |
| (Missing) |
| Value | Count | Frequency (%) | |
| QXRTCZ | 10 | 0.2% | |
| MU7XPH | 8 | 0.1% | |
| UPOMOM | 8 | 0.1% | |
| XHAYAN | 6 | 0.1% | |
| 2P32PJ OFOJ6S | 6 | 0.1% | |
| NPN5FB | 6 | 0.1% | |
| NCHNGM | 5 | 0.1% | |
| EQWCXJ | 5 | 0.1% | |
| OLLF6J | 5 | 0.1% | |
| 2MVC3M | 4 | 0.1% | |
| Other values (3256) | 3707 | 67.4% | |
| (Missing) | 1729 | 31.4% |
| Max length | 20 |
|---|---|
| Mean length | 5.330423713 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
Receiptdoesnotmatchclaim
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 | 70 |
| Value | Count | Frequency (%) | |
| 0 | 5429 | 98.7% | |
| 1 | 70 | 1.3% |
Reference
Categorical
| Distinct count | 111 |
|---|---|
| Unique (%) | 2.0% |
| Missing (%) | 95.0% |
| Missing (n) | 5222 |
| 80NF | 52 |
|---|---|
| RS | 16 |
| FX/BWI | 10 |
| Other values (107) | 199 |
| (Missing) |
| Value | Count | Frequency (%) | |
| 80NF | 52 | 0.9% | |
| RS | 16 | 0.3% | |
| FX/BWI | 10 | 0.2% | |
| WP | 10 | 0.2% | |
| RD/NE | 8 | 0.1% | |
| 80/NF | 7 | 0.1% | |
| BA3 | 6 | 0.1% | |
| FLY NE | 6 | 0.1% | |
| BA10/11 | 6 | 0.1% | |
| FLY 12/15/82 | 6 | 0.1% | |
| Other values (100) | 150 | 2.7% | |
| (Missing) | 5222 | 95.0% |
| Max length | 30 |
|---|---|
| Mean length | 3.311329333 |
| Min length | 2 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
Regulation_Unauthorized
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 | 110 |
| Value | Count | Frequency (%) | |
| 0 | 5389 | 98.0% | |
| 1 | 110 | 2.0% |
ReturnDate
Categorical
| Distinct count | 467 |
|---|---|
| Unique (%) | 8.5% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 2/1/20 | 60 |
|---|---|
| 9/20/19 | 58 |
| 9/27/19 | 58 |
| Other values (464) |
| Value | Count | Frequency (%) | |
| 2/1/20 | 60 | 1.1% | |
| 9/20/19 | 58 | 1.1% | |
| 9/27/19 | 58 | 1.1% | |
| 12/13/19 | 57 | 1.0% | |
| 6/15/19 | 57 | 1.0% | |
| 11/22/19 | 56 | 1.0% | |
| 1/31/20 | 55 | 1.0% | |
| 3/14/20 | 53 | 1.0% | |
| 10/30/19 | 53 | 1.0% | |
| 9/30/19 | 48 | 0.9% | |
| Other values (457) | 4944 | 89.9% |
| Max length | 8 |
|---|---|
| Mean length | 7.013456992 |
| Min length | 6 |
| Contains chars | False |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | True |
Reviewed_Record
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 4556 | 82.9% | |
| 1 | 943 | 17.1% |
ReviewedVouchers
Highly correlated
This variable is highly correlated with Reviewed_Record and should be ignored for analysis
| Correlation | 1 |
|---|
SDN(representativeSDNfordoctype)
Categorical
| Distinct count | 4942 |
|---|---|
| Unique (%) | 89.9% |
| Missing (%) | 0.5% |
| Missing (n) | 28 |
| 2CT6YJ TD | 10 |
|---|---|
| 2CKT31 TD | 6 |
| 2CWX4L TD | 6 |
| Other values (4938) | |
| (Missing) | 28 |
| Value | Count | Frequency (%) | |
| 2CT6YJ TD | 10 | 0.2% | |
| 2CKT31 TD | 6 | 0.1% | |
| 2CWX4L TD | 6 | 0.1% | |
| 26UZR4 TD | 6 | 0.1% | |
| 2BBQ9U | 5 | 0.1% | |
| 2C7V91 TD | 5 | 0.1% | |
| 2A38PA TD | 5 | 0.1% | |
| 2BBQ9U TD | 5 | 0.1% | |
| 2D49YM TD | 4 | 0.1% | |
| 2CUTTU TD | 4 | 0.1% | |
| Other values (4931) | 5415 | 98.5% | |
| (Missing) | 28 | 0.5% |
| Max length | 19 |
|---|---|
| Mean length | 9.962720495 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
Sent_Date
Categorical
| Distinct count | 15 |
|---|---|
| Unique (%) | 0.3% |
| Missing (%) | 96.1% |
| Missing (n) | 5283 |
| 8/21/19 | 43 |
|---|---|
| 10/31/19 | 41 |
| 12/5/19 | 34 |
| Other values (11) | 98 |
| (Missing) |
| Value | Count | Frequency (%) | |
| 8/21/19 | 43 | 0.8% | |
| 10/31/19 | 41 | 0.7% | |
| 12/5/19 | 34 | 0.6% | |
| 5/4/20 | 25 | 0.5% | |
| 7/16/19 | 18 | 0.3% | |
| 3/10/20 | 16 | 0.3% | |
| 7/17/19 | 8 | 0.1% | |
| 5/12/20 | 7 | 0.1% | |
| 2/21/20 | 7 | 0.1% | |
| 11/4/19 | 7 | 0.1% | |
| Other values (4) | 10 | 0.2% | |
| (Missing) | 5283 | 96.1% |
| Max length | 8 |
|---|---|
| Mean length | 3.160029096 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | True |
SignedDate
Categorical
| Distinct count | 355 |
|---|---|
| Unique (%) | 6.5% |
| Missing (%) | < 0.1% |
| Missing (n) | 1 |
| 11/25/19 | 60 |
|---|---|
| 9/30/19 | 56 |
| 9/9/19 | 46 |
| Other values (351) |
| Value | Count | Frequency (%) | |
| 11/25/19 | 60 | 1.1% | |
| 9/30/19 | 56 | 1.0% | |
| 9/9/19 | 46 | 0.8% | |
| 11/26/19 | 46 | 0.8% | |
| 8/20/19 | 44 | 0.8% | |
| 3/9/20 | 43 | 0.8% | |
| 12/18/19 | 42 | 0.8% | |
| 1/21/20 | 41 | 0.7% | |
| 2/3/20 | 41 | 0.7% | |
| 10/15/19 | 41 | 0.7% | |
| Other values (344) | 5038 | 91.6% |
| Max length | 8 |
|---|---|
| Mean length | 6.994544463 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | True |
SpecialCircumstancesTripType
Constant
This variable is constant and should be ignored for analysis
| Constant value | nan |
|---|
SPPReject(Y/N)
Categorical
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 6.7% |
| Missing (n) | 368 |
| N | |
|---|---|
| (Missing) | 368 |
| Value | Count | Frequency (%) | |
| N | 5131 | 93.3% | |
| (Missing) | 368 | 6.7% |
| Max length | 3 |
|---|---|
| Mean length | 1.133842517 |
| Min length | 1 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | False |
| Contains non-words | False |
SSN
Categorical
| Distinct count | 1077 |
|---|---|
| Unique (%) | 19.6% |
| Missing (%) | 6.7% |
| Missing (n) | 368 |
| *****6633 | 37 |
|---|---|
| *****3312 | 35 |
| *****887R | 31 |
| Other values (1073) | |
| (Missing) | 368 |
| Value | Count | Frequency (%) | |
| *****6633 | 37 | 0.7% | |
| *****3312 | 35 | 0.6% | |
| *****887R | 31 | 0.6% | |
| *****3829 | 28 | 0.5% | |
| *****2061 | 28 | 0.5% | |
| *****9772 | 27 | 0.5% | |
| *****2662 | 26 | 0.5% | |
| *****0507 | 26 | 0.5% | |
| *****8714 | 26 | 0.5% | |
| *****7831 | 26 | 0.5% | |
| Other values (1066) | 4841 | 88.0% | |
| (Missing) | 368 | 6.7% |
| Max length | 9 |
|---|---|
| Mean length | 8.59847245 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | True |
T-EnteredFlag
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| N | |
|---|---|
| Y | 80 |
| Value | Count | Frequency (%) | |
| N | 5419 | 98.5% | |
| Y | 80 | 1.5% |
TANum
Categorical
| Distinct count | 4887 |
|---|---|
| Unique (%) | 88.9% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 2BBQ9U | 10 |
|---|---|
| 2CT6YJ | 10 |
| 2747I7 | 8 |
| Other values (4884) |
| Value | Count | Frequency (%) | |
| 2BBQ9U | 10 | 0.2% | |
| 2CT6YJ | 10 | 0.2% | |
| 2747I7 | 8 | 0.1% | |
| 2CKT31 | 6 | 0.1% | |
| 26XOI2 | 6 | 0.1% | |
| 26UZR4 | 6 | 0.1% | |
| 2CWX4L | 6 | 0.1% | |
| 2CYM1U | 6 | 0.1% | |
| 2C7V91 | 5 | 0.1% | |
| 2CQE7V | 5 | 0.1% | |
| Other values (4877) | 5431 | 98.8% |
| Max length | 6 |
|---|---|
| Mean length | 6 |
| Min length | 6 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | False |
TotalCP-C/CR-CAmount
Numeric
| Distinct count | 19 |
|---|---|
| Unique (%) | 0.3% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 4.068894344 |
|---|---|
| Minimum | 0 |
| Maximum | 13278.15 |
| Zeros (%) | 99.6% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 13278.15 |
| Range | 13278.15 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 182.6894517 |
|---|---|
| Coef of variation | 44.89904043 |
| Kurtosis | 5074.461029 |
| Mean | 4.068894344 |
| MAD | 8.106711482 |
| Skewness | 70.0678505 |
| Sum | 22374.85 |
| Variance | 33375.43576 |
| Memory size | 43.1 KiB |
| Value | Count | Frequency (%) | |
| 0 | 5478 | 99.6% | |
| 457.4 | 2 | < 0.1% | |
| 212.8 | 2 | < 0.1% | |
| 8.35 | 2 | < 0.1% | |
| 623.6 | 1 | < 0.1% | |
| 1949 | 1 | < 0.1% | |
| 497.6 | 1 | < 0.1% | |
| 426.5 | 1 | < 0.1% | |
| 278.8 | 1 | < 0.1% | |
| 494.28 | 1 | < 0.1% | |
| Other values (9) | 9 | 0.2% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 5478 | 99.6% | |
| 8.35 | 2 | < 0.1% | |
| 32.02 | 1 | < 0.1% | |
| 212.8 | 2 | < 0.1% | |
| 220.6 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 13278.15 | 1 | < 0.1% | |
| 1949 | 1 | < 0.1% | |
| 662.8 | 1 | < 0.1% | |
| 623.6 | 1 | < 0.1% | |
| 575.3 | 1 | < 0.1% |
TotalCP/CRAmount
Numeric
| Distinct count | 1153 |
|---|---|
| Unique (%) | 21.0% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 349.6803673 |
|---|---|
| Minimum | 0 |
| Maximum | 5218.05 |
| Zeros (%) | 52.6% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 499.8 |
| 95-th percentile | 1397.451 |
| Maximum | 5218.05 |
| Range | 5218.05 |
| Interquartile range | 499.8 |
Descriptive statistics
| Standard deviation | 576.8844909 |
|---|---|
| Coef of variation | 1.649748012 |
| Kurtosis | 13.74087923 |
| Mean | 349.6803673 |
| MAD | 390.8086792 |
| Skewness | 3.048717964 |
| Sum | 1922892.34 |
| Variance | 332795.7159 |
| Memory size | 43.1 KiB |
| Value | Count | Frequency (%) | |
| 0 | 2891 | 52.6% | |
| 220.6 | 68 | 1.2% | |
| 280.6 | 50 | 0.9% | |
| 212.8 | 48 | 0.9% | |
| 212.6 | 37 | 0.7% | |
| 278.6 | 36 | 0.7% | |
| 658.6 | 30 | 0.5% | |
| 278.8 | 30 | 0.5% | |
| 706.6 | 23 | 0.4% | |
| 1348.61 | 21 | 0.4% | |
| Other values (1143) | 2265 | 41.2% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 2891 | 52.6% | |
| 6.23 | 1 | < 0.1% | |
| 8.35 | 1 | < 0.1% | |
| 81.3 | 2 | < 0.1% | |
| 83.3 | 2 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 5218.05 | 2 | < 0.1% | |
| 5104.99 | 2 | < 0.1% | |
| 4885.28 | 2 | < 0.1% | |
| 4788.33 | 1 | < 0.1% | |
| 4458.95 | 1 | < 0.1% |
TotalDaysTDY
Numeric
| Distinct count | 115 |
|---|---|
| Unique (%) | 2.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 9.534097109 |
|---|---|
| Minimum | 1 |
| Maximum | 382 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| Median | 4 |
| Q3 | 7 |
| 95-th percentile | 37.1 |
| Maximum | 382 |
| Range | 381 |
| Interquartile range | 5 |
Descriptive statistics
| Standard deviation | 22.89717298 |
|---|---|
| Coef of variation | 2.401608954 |
| Kurtosis | 106.6839831 |
| Mean | 9.534097109 |
| MAD | 9.598986554 |
| Skewness | 8.746903959 |
| Sum | 52428 |
| Variance | 524.2805305 |
| Memory size | 43.1 KiB |
| Value | Count | Frequency (%) | |
| 2 | 1290 | 23.5% | |
| 3 | 769 | 14.0% | |
| 4 | 540 | 9.8% | |
| 1 | 532 | 9.7% | |
| 5 | 480 | 8.7% | |
| 6 | 341 | 6.2% | |
| 7 | 174 | 3.2% | |
| 8 | 161 | 2.9% | |
| 13 | 100 | 1.8% | |
| 9 | 95 | 1.7% | |
| Other values (105) | 1017 | 18.5% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 1 | 532 | 9.7% | |
| 2 | 1290 | 23.5% | |
| 3 | 769 | 14.0% | |
| 4 | 540 | 9.8% | |
| 5 | 480 | 8.7% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 382 | 4 | 0.1% | |
| 354 | 2 | < 0.1% | |
| 282 | 6 | 0.1% | |
| 271 | 1 | < 0.1% | |
| 262 | 2 | < 0.1% |
TotalInputError
Highly correlated
This variable is highly correlated with InputError and should be ignored for analysis
| Correlation | 1 |
|---|
TotalMiscellaneous
Highly correlated
This variable is highly correlated with Miscellaneous and should be ignored for analysis
| Correlation | 1 |
|---|
TotalMissingInvalidReceiptDocumentation
Highly correlated
This variable is highly correlated with Missing_InvalidReceipt_Documentation and should be ignored for analysis
| Correlation | 1 |
|---|
TotalReceiptDoesNotMatchClaim
Highly correlated
This variable is highly correlated with Receiptdoesnotmatchclaim and should be ignored for analysis
| Correlation | 1 |
|---|
TotalRegulationUnauthorized
Highly correlated
This variable is highly correlated with Regulation_Unauthorized and should be ignored for analysis
| Correlation | 1 |
|---|
TotalReimbursableExpenses
Highly correlated
This variable is highly correlated with AmountClaim and should be ignored for analysis
| Correlation | 0.9993386598 |
|---|
TotalTripExpenses
Highly correlated
This variable is highly correlated with TotalReimbursableExpenses and should be ignored for analysis
| Correlation | 0.9988470133 |
|---|
Travel_Location
Categorical
| Distinct count | 498 |
|---|---|
| Unique (%) | 9.1% |
| Missing (%) | 9.6% |
| Missing (n) | 529 |
| NORFOLK NAVAL STATION,VA | 289 |
|---|---|
| WASHINGTON,DC | 228 |
| MACDILL AFB,FL | 124 |
| Other values (494) | |
| (Missing) | 529 |
| Value | Count | Frequency (%) | |
| NORFOLK NAVAL STATION,VA | 289 | 5.3% | |
| WASHINGTON,DC | 228 | 4.1% | |
| MACDILL AFB,FL | 124 | 2.3% | |
| SCOTT AFB,IL | 121 | 2.2% | |
| PENTAGON,VA | 106 | 1.9% | |
| MEMPHIS,TN | 106 | 1.9% | |
| RAMSTEIN AB,DEU | 97 | 1.8% | |
| SIGONELLA NAS,ITA | 93 | 1.7% | |
| MILITARY BASES NOT IN KUWAIT CITY,KWT | 82 | 1.5% | |
| SAN ANTONIO,TX | 79 | 1.4% | |
| Other values (487) | 3645 | 66.3% | |
| (Missing) | 529 | 9.6% |
| Max length | 47 |
|---|---|
| Mean length | 14.78868885 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
TravelerEmailAddress
Categorical
| Distinct count | 1152 |
|---|---|
| Unique (%) | 20.9% |
| Missing (%) | 6.7% |
| Missing (n) | 368 |
| james.e.shepard22.mil@mail.mil | 73 |
|---|---|
| donald.b.absher.mil@mail.mil | 31 |
| kayla.m.georgiafandis.mil@mail.mil | 28 |
| Other values (1148) | |
| (Missing) | 368 |
| Value | Count | Frequency (%) | |
| james.e.shepard22.mil@mail.mil | 73 | 1.3% | |
| donald.b.absher.mil@mail.mil | 31 | 0.6% | |
| kayla.m.georgiafandis.mil@mail.mil | 28 | 0.5% | |
| JOSEPH.REICHERT@US.AF.MIL | 28 | 0.5% | |
| shawn.m.bedard.mil@mail.mil | 27 | 0.5% | |
| stewart.harrison@me.navy.mil | 26 | 0.5% | |
| tracey.turner.3@us.af.mil | 26 | 0.5% | |
| ANDREA.GONZALES.5@US.AF.MIL | 26 | 0.5% | |
| horace.e.taylor13.mil@mail.mil | 26 | 0.5% | |
| andrew.kruczyk@us.af.mil | 25 | 0.5% | |
| Other values (1141) | 4815 | 87.6% | |
| (Missing) | 368 | 6.7% |
| Max length | 55 |
|---|---|
| Mean length | 25.74777232 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | True |
TravelerFirstName
Categorical
| Distinct count | 616 |
|---|---|
| Unique (%) | 11.2% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| CHRISTOPHER | 122 |
|---|---|
| JAMES | 120 |
| MATTHEW | 98 |
| Other values (613) |
| Value | Count | Frequency (%) | |
| CHRISTOPHER | 122 | 2.2% | |
| JAMES | 120 | 2.2% | |
| MATTHEW | 98 | 1.8% | |
| JOHN | 93 | 1.7% | |
| DAVID | 92 | 1.7% | |
| MICHAEL | 90 | 1.6% | |
| ROBERT | 85 | 1.5% | |
| ANDREW | 74 | 1.3% | |
| WILLIAM | 73 | 1.3% | |
| RICHARD | 70 | 1.3% | |
| Other values (606) | 4582 | 83.3% |
| Max length | 15 |
|---|---|
| Mean length | 6.142389525 |
| Min length | 1 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
TravelerLastName
Categorical
| Distinct count | 1005 |
|---|---|
| Unique (%) | 18.3% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| JOHNSON | 57 |
|---|---|
| JONES | 47 |
| TURNER | 45 |
| Other values (1002) |
| Value | Count | Frequency (%) | |
| JOHNSON | 57 | 1.0% | |
| JONES | 47 | 0.9% | |
| TURNER | 45 | 0.8% | |
| WILLIAMS | 40 | 0.7% | |
| Shepard | 38 | 0.7% | |
| LYONS | 37 | 0.7% | |
| SMITH | 37 | 0.7% | |
| REICHERT | 32 | 0.6% | |
| ABSHER | 31 | 0.6% | |
| GONZALES | 31 | 0.6% | |
| Other values (995) | 5104 | 92.8% |
| Max length | 18 |
|---|---|
| Mean length | 6.533733406 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
TripDescription
Categorical
| Distinct count | 3510 |
|---|---|
| Unique (%) | 63.8% |
| Missing (%) | 21.7% |
| Missing (n) | 1194 |
| DELIVERY OF CLASSIFED COURIER MATERIAL | 28 |
|---|---|
| Deliver DCS material | 16 |
| Delivery of classified material. | 14 |
| Other values (3506) | |
| (Missing) |
| Value | Count | Frequency (%) | |
| DELIVERY OF CLASSIFED COURIER MATERIAL | 28 | 0.5% | |
| Deliver DCS material | 16 | 0.3% | |
| Delivery of classified material. | 14 | 0.3% | |
| Courier duties; escort DCS material | 13 | 0.2% | |
| Delivery of DCS Material | 11 | 0.2% | |
| TDY | 10 | 0.2% | |
| DoD Courier Mission. | 9 | 0.2% | |
| Delivering DCS material | 8 | 0.1% | |
| Delivery of classified courier material. | 8 | 0.1% | |
| Attending 42A Advance Leader Course at Fort Jackson South Carolina. Will also be taking leave after completing ALC.PNR Locator:UPOMOM | 8 | 0.1% | |
| Other values (3499) | 4180 | 76.0% | |
| (Missing) | 1194 | 21.7% |
| Max length | 1458 |
|---|---|
| Mean length | 44.65048191 |
| Min length | 2 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
TripPurpose
Categorical
| Distinct count | 13 |
|---|---|
| Unique (%) | 0.2% |
| Missing (%) | 3.0% |
| Missing (n) | 166 |
| MISSION - OPERATIONAL | |
|---|---|
| TRAINING | |
| CONFERENCE- NON-TRAINING | 442 |
| Other values (9) |
| Value | Count | Frequency (%) | |
| MISSION - OPERATIONAL | 2999 | 54.5% | |
| TRAINING | 1258 | 22.9% | |
| CONFERENCE- NON-TRAINING | 442 | 8.0% | |
| SPECIAL AGENCY MISSION | 328 | 6.0% | |
| TRAINING ATTENDANCE | 105 | 1.9% | |
| OTHER TRAVEL | 81 | 1.5% | |
| SPECIAL MISSION TRAVEL | 60 | 1.1% | |
| SITE VISIT | 21 | 0.4% | |
| EMERGENCY - PERSONAL | 18 | 0.3% | |
| CONFERENCE ATTENDANCE | 12 | 0.2% | |
| Other values (2) | 9 | 0.2% | |
| (Missing) | 166 | 3.0% |
| Max length | 24 |
|---|---|
| Mean length | 17.57719585 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
TripType
Categorical
| Distinct count | 8 |
|---|---|
| Unique (%) | 0.1% |
| Missing (%) | 3.0% |
| Missing (n) | 166 |
| Temporary Duty Travel (Routine) | |
|---|---|
| Invitational Travel | 12 |
| Dependent Invitational Travel | 10 |
| Other values (4) | 25 |
| (Missing) | 166 |
| Value | Count | Frequency (%) | |
| Temporary Duty Travel (Routine) | 5286 | 96.1% | |
| Invitational Travel | 12 | 0.2% | |
| Dependent Invitational Travel | 10 | 0.2% | |
| Dependent Invitational Travel - Transportation Expenses Only | 9 | 0.2% | |
| AA-ROUTINE TDY/TAD | 9 | 0.2% | |
| Government Funded Leave | 6 | 0.1% | |
| Invitational Travel - Transportation Expenses Only | 1 | < 0.1% | |
| (Missing) | 166 | 3.0% |
| Max length | 60 |
|---|---|
| Mean length | 30.1458447 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
Underpayments(Credits)*
Numeric
| Distinct count | 57 |
|---|---|
| Unique (%) | 1.0% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 1.961745772 |
|---|---|
| Minimum | 0 |
| Maximum | 3428.7 |
| Zeros (%) | 98.7% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 3428.7 |
| Range | 3428.7 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 55.51183748 |
|---|---|
| Coef of variation | 28.29716178 |
| Kurtosis | 2949.234936 |
| Mean | 1.961745772 |
| MAD | 3.873183414 |
| Skewness | 51.72512377 |
| Sum | 10787.64 |
| Variance | 3081.564101 |
| Memory size | 43.1 KiB |
| Value | Count | Frequency (%) | |
| 0 | 5428 | 98.7% | |
| 8.35 | 5 | 0.1% | |
| 30.5 | 4 | 0.1% | |
| 28 | 3 | 0.1% | |
| 33 | 2 | < 0.1% | |
| 46 | 2 | < 0.1% | |
| 38 | 2 | < 0.1% | |
| 13.75 | 2 | < 0.1% | |
| 27.5 | 2 | < 0.1% | |
| 10 | 2 | < 0.1% | |
| Other values (47) | 47 | 0.9% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 5428 | 98.7% | |
| 1 | 1 | < 0.1% | |
| 3.16 | 1 | < 0.1% | |
| 6.36 | 1 | < 0.1% | |
| 8.35 | 5 | 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 3428.7 | 1 | < 0.1% | |
| 1998.43 | 1 | < 0.1% | |
| 584.5 | 1 | < 0.1% | |
| 399.36 | 1 | < 0.1% | |
| 384.79 | 1 | < 0.1% |
Underpayments_(Credits)*
Highly correlated
This variable is highly correlated with Underpayments(Credits)* and should be ignored for analysis
| Correlation | 1 |
|---|
First rows
| Actuals(Y/N) | AdvanceAmount | AdvanceReject(Y/N) | Advisory | AmountClaim | AOEmailAddress | AutoKey | AwaitingStatus | CancelledDate | Changes_Needed_(Y/N) | Comments | ConstructiveTravelFlag | Corrected_Date | CorrectedVouchers | CurrentStatus | CurrentVersionCompletedDate | DateofCurrentStatus | DCSSuborganization | DepartureDate | df_index | Directorate | DocumentCreateDate | DocumentName | DocumentType | DTAIDEmailAddress | Error_Category | ExpensesbyLOA | FinancialReject(Y/N) | ForeignTravelFlag | FullName | ImproperPaymentCorrections | ImproperPayments | IncludesSPP(Y/N) | InputError | LastAOApprovedDate | LOA10by20 | LOALabel | Location/Destination(firstonly) | Miscellaneous | Missing_InvalidReceipt_Documentation | Month_End | Month_Rank | MultipleLOAs(Y/N) | Non-contractFareFlag | Organization/Suborganization | Overpayments(Debts)* | Overpayments_(Debts)* | PNRRecordLocator(allshown) | Receiptdoesnotmatchclaim | Reference | Regulation_Unauthorized | ReturnDate | Reviewed_Record | ReviewedVouchers | SDN(representativeSDNfordoctype) | Sent_Date | SignedDate | SpecialCircumstancesTripType | SPPReject(Y/N) | SSN | T-EnteredFlag | TANum | TotalCP-C/CR-CAmount | TotalCP/CRAmount | TotalDaysTDY | TotalInputError | TotalMiscellaneous | TotalMissingInvalidReceiptDocumentation | TotalReceiptDoesNotMatchClaim | TotalRegulationUnauthorized | TotalReimbursableExpenses | TotalTripExpenses | Travel_Location | TravelerEmailAddress | TravelerFirstName | TravelerLastName | TripDescription | TripPurpose | TripType | Underpayments(Credits)* | Underpayments_(Credits)* | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | N | 0.0 | N | 0.0 | 5999.20 | michael.w.muskopf.civ@mail.mil | 69710.0 | NaN | NaN | NaN | NaN | N | NaN | 0.0 | ARCHIVE IMAGE ACCEPT | 5/5/20 | 5/6/20 | NaN | 1/12/20 | 0 | TCAQ | 5/5/20 | CLMAXWELLAFBA011220_V01-01 | VCH | transcom.scott.tcj8.mbx.dts-rejects@mail.mil | NaN | 5999.20 | N | N | CHAD LINDAUER | 0.0 | 0.0 | N | 0.0 | 5/5/20 | 387700^57^^0^3400^^30^^64^ET^1L3L24^03^^^^^40915^^^387700^^^84751F^^^^^ | 20 1L3L24 | MAXWELL AFB,AL | 0.0 | 0.0 | 5/31/20 | 1.0 | N | N | DJ60TCAQ | 0.00 | 0.00 | NaN | 0.0 | NaN | 0.0 | 2/27/20 | 0.0 | 0.0 | 2DMMRK TD | NaN | 5/5/20 | NaN | N | *****3308 | N | 2DMMRK | 0.0 | 0.0 | 47.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 5999.20 | 5999.20 | MAXWELL AFB,AL | chad.s.lindauer.civ@mail.mil | CHAD | LINDAUER | TLN 9S3T000017Course Title: SQUADRON OFFICER SCHOOLCourse #: MSOS 001 CLASSNumber: 2020BCSD: 13 JAN 2020 - CGD: 27 FEB 2020Location: MAXWELL AFB | TRAINING | Temporary Duty Travel (Routine) | 0.0 | 0.0 |
| 1 | N | 0.0 | N | 0.0 | 0.00 | mary.b.gaffney.civ@mail.mil | 69711.0 | NaN | NaN | No | Okay | N | NaN | 0.0 | ARCHIVE ACCEPTED | 5/14/20 | 5/15/20 | NaN | 3/23/20 | 2 | TCAQ | 3/12/20 | TTCOLUMBUSOH032320_V01 | VCH | transcom.scott.tcj8.mbx.dts-rejects@mail.mil | NaN | 0.00 | N | N | TAMARA THOUVENOT | 0.0 | 0.0 | N | 0.0 | 5/14/20 | 387700^97^^X^4930^FD50^6F^0^70^AB^G04N70^^_12400^^^^40924^^^387700^^^48090D^^^^^ | 20 TCAQ MSPT | COLUMBUS,OH | 0.0 | 0.0 | 5/31/20 | 1.0 | N | N | DJ60TCAQ | 0.00 | 0.00 | NaN | 0.0 | NaN | 0.0 | 3/24/20 | 1.0 | 1.0 | 2E56SM TD | NaN | 5/14/20 | NaN | N | *****4081 | N | 2E56SM | 0.0 | 0.0 | 2.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.00 | 0.00 | COLUMBUS,OH | tamara.d.thouvenot.civ@mail.mil | TAMARA | THOUVENOT | DLA Land and Maritime Guest SpeakerPNR Locator:N3D8YZ | MISSION - OPERATIONAL | Temporary Duty Travel (Routine) | 0.0 | 0.0 |
| 2 | N | 0.0 | N | 0.0 | 254.51 | brian.l.paul2.civ@mail.mil | 69712.0 | NaN | NaN | No | Okay | N | NaN | 0.0 | REJECT | 5/15/20 | 5/18/20 | NaN | 9/12/19 | 3 | TCCC | 4/23/20 | ABSTLOUISMO091219_V01 | VCH | transcom.scott.tcj8.mbx.dts-rejects@mail.mil | NaN | 787.36 | Y | N | ALAN BECKENSTEIN | 0.0 | 0.0 | N | 0.0 | 5/15/20 | 387700^97^^X^4930^FD50^6F^9^70^AB^G00000^^_12400^^^^40924^^^387700^^^48090D^^^^^ | 19 CMDSEC MSPT | ST. LOUIS,MO | 0.0 | 0.0 | 5/31/20 | 1.0 | N | N | DJ60TCCC | 0.00 | 0.00 | 4N42B2 | 0.0 | NaN | 0.0 | 9/13/19 | 1.0 | 1.0 | 2CS1JU TD | NaN | 5/15/20 | NaN | N | *****6524 | Y | 2CS1JU | 524.5 | 0.0 | 2.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 254.51 | 787.36 | ST. LOUIS,MO | kendall.e.martin2.civ@mail.mil | Alan | Beckenstein | PNR Locator:4N42B2 | TRAINING | Invitational Travel | 0.0 | 0.0 |
| 3 | N | 0.0 | N | 0.0 | 135.00 | richard.h.espinosa.mil@mail.mil | 69713.0 | NaN | NaN | NaN | NaN | N | NaN | 0.0 | ARCHIVE IMAGE ACCEPT | 5/15/20 | 5/18/20 | NaN | 10/10/19 | 4 | TCCC | 5/13/20 | DM101019_L01.4-01 | LVCH | transcom.scott.tcj8.mbx.dts-rejects@mail.mil | NaN | 135.00 | N | N | DEE MEWBOURNE | 0.0 | 0.0 | N | 0.0 | 5/15/20 | 387700^97^^X^4930^FD50^6F^0^70^AB^G00000^^_12400^^^^40924^^^387700^^^48090D^^^^^ | 20 CMDSEC MSPT | NaN | 0.0 | 0.0 | 5/31/20 | 1.0 | N | N | DJ60TCCC | 0.00 | 0.00 | NaN | 0.0 | NDTA Fall Meeting | 0.0 | 10/10/19 | 0.0 | 0.0 | 2D0XUV TD | NaN | 5/13/20 | NaN | N | *****6477 | N | 2D0XUV | 0.0 | 0.0 | 1.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 135.00 | 135.00 | NaN | kayla.m.georgiafandis.mil@mail.mil | DEE | MEWBOURNE | NaN | NaN | NaN | 0.0 | 0.0 |
| 4 | N | 0.0 | N | 0.0 | 8.35 | richard.h.espinosa.mil@mail.mil | 69714.0 | NaN | NaN | NaN | NaN | N | NaN | 0.0 | ARCHIVE IMAGE ACCEPT | 5/11/20 | 5/12/20 | NaN | 12/11/19 | 5 | TCCC | 5/7/20 | DMWASHINGTOND121119_V02-01 | VCH | transcom.scott.tcj8.mbx.dts-rejects@mail.mil | NaN | 8.35 | N | N | DEE MEWBOURNE | 0.0 | 0.0 | N | 0.0 | 5/11/20 | 387700^97^^X^4930^FD50^6F^0^70^AB^G00000^^_12400^^^^40924^^^387700^^^48090D^^^^^ | 20 CMDSEC MSPT | WASHINGTON,DC | 0.0 | 0.0 | 5/31/20 | 1.0 | N | N | DJ60TCCC | 0.00 | 0.00 | 74FPOO | 0.0 | NaN | 0.0 | 12/12/19 | 0.0 | 0.0 | 2DGYP1 TD | NaN | 5/11/20 | NaN | N | *****6477 | N | 2DGYP1 | 0.0 | 0.0 | 2.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 8.35 | 8.35 | WASHINGTON,DC | kayla.m.georgiafandis.mil@mail.mil | DEE | MEWBOURNE | Attending NDTA Holiday Reception and Board of Directors followed by 3 days of personal leavePNR Locator:74FPOO | MISSION - OPERATIONAL | Temporary Duty Travel (Routine) | 0.0 | 0.0 |
| 5 | N | 0.0 | N | 0.0 | 16.70 | richard.h.espinosa.mil@mail.mil | 69715.0 | NaN | NaN | No | Okay | N | NaN | 0.0 | ARCHIVE IMAGE ACCEPT | 5/15/20 | 5/19/20 | NaN | 3/17/20 | 6 | TCCC | 3/13/20 | KTSEATTLEWA031320_V01 | VCH | transcom.scott.tcj8.mbx.dts-rejects@mail.mil | NaN | 16.70 | N | N | KHRISTIAN THOMPSON | 0.0 | 0.0 | N | 0.0 | 5/15/20 | 387700^97^^X^4930^FD50^6F^0^70^AB^G00000^^_12400^^^^40924^^^387700^^^48090D^^^^^ | 20 CMDSEC MSPT | WASHINGTON NAVAL DISTRICT,DC | 0.0 | 0.0 | 5/31/20 | 1.0 | N | N | DJ60TCCC | 0.00 | 0.00 | NaN | 0.0 | NaN | 0.0 | 3/18/20 | 1.0 | 1.0 | 2EGVDH TD | NaN | 5/13/20 | NaN | N | *****0105 | N | 2EGVDH | 0.0 | 0.0 | 2.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 16.70 | 16.70 | WASHINGTON NAVAL DISTRICT,DC | khristian.b.thompson.mil@mail.mil | KHRISTIAN | THOMPSON | Conduct Advance Protective Security Operations in support of a TDY of the CDRUSTRANSCOMPNR Locator:73F24S PNR Locator:L3FEFL | MISSION - OPERATIONAL | Temporary Duty Travel (Routine) | 0.0 | 0.0 |
| 6 | N | 0.0 | N | 0.0 | 113.82 | DEON.C.EVANS2.MIL@MAIL.MIL | 69716.0 | NaN | NaN | Yes | Traveler claimed the mileage from his home to SIU Edwardsville was 66 miles. According to Google it is 32.6. When claiming local mileage you can only claim the mileage above what your daily commute to the Duty Station. His daily commute is 6.1 miles, he entered it as 33 miles. 66-33 = 33 but it should have been 33 - 6 = 27. Traveler was over paid 12 miles a day for a total of $20.64. Please correct mileage numbers. | N | NaN | 0.0 | ARCHIVE ACCEPTED | 5/21/20 | 5/22/20 | NaN | 3/10/20 | 7 | TCJ1 | 3/13/20 | MR031320_L01 | LVCH | transcom.scott.tcj8.mbx.dts-rejects@mail.mil | NaN | 113.82 | N | N | MITCHELL ROBINSON | 9999.0 | 1.0 | N | 1.0 | 5/21/20 | 387700^97^^X^4930^FD50^6F^0^70^AB^G041D0^^_12400^^^^40924^^^387700^^^48090D^^^^^ | 20 J1 MSPT | NaN | 0.0 | 0.0 | 5/31/20 | 1.0 | N | N | DJ60TCJ1 | 20.64 | 20.64 | NaN | 0.0 | NaN | 1.0 | 3/12/20 | 1.0 | 1.0 | 2FELUP TD | NaN | 3/16/20 | NaN | N | *****2723 | N | 2FELUP | 0.0 | 0.0 | 3.0 | 1.0 | 0.0 | 0.0 | 0.0 | 1.0 | 113.82 | 113.82 | NaN | mitchell.j.robinson6.civ@mail.mil | MITCHELL | ROBINSON | NaN | NaN | NaN | 0.0 | 0.0 |
| 7 | N | 0.0 | N | 0.0 | 4010.33 | donald.d.johnson70.mil@mail.mil | 69717.0 | NaN | NaN | Yes | Traveler claimed a Roadside Assistance protection fee he was charged on his rental receipt, which is not an authorized reimbursement. This service is included in the GARS fee he was charged. Rental car claim needs to be reduced by $118.83. Traveler should contact Enterprise and see if he can get them to remove the charge and provide him a credit. | N | NaN | 0.0 | ARCHIVE IMAGE ACCEPT | 5/26/20 | 5/27/20 | NaN | 5/3/20 | 11 | TCJ1 | 5/21/20 | WJSANANTONIOT050320_V01 | VCH | transcom.scott.tcj8.mbx.dts-rejects@mail.mil | NaN | 4010.33 | N | N | WISTARIA JOSEPH | 9999.0 | 1.0 | N | 0.0 | 5/26/20 | 387700^57^^0^3400^^30^^15^4A^BKOPB1^04^^^^^40924^^^387700^^^91212F^^^^^ | 20 3AFELM | SAN ANTONIO,TX | 0.0 | 0.0 | 5/31/20 | 1.0 | Y | N | DJ60TCJ1 | 118.83 | 118.83 | 3NL75D | 0.0 | NaN | 1.0 | 5/20/20 | 1.0 | 1.0 | 2F41TY TD | NaN | 5/24/20 | NaN | N | *****6411 | N | 2F41TY | 0.0 | 659.2 | 18.0 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 | 4010.33 | 4010.33 | SAN ANTONIO,TX | wistaria.j.joseph.mil@mail.mil | WISTARIA | JOSEPH | PNR Locator:3NL75D | MISSION - OPERATIONAL | Temporary Duty Travel (Routine) | 0.0 | 0.0 |
| 8 | N | 0.0 | N | 0.0 | 4010.33 | donald.d.johnson70.mil@mail.mil | 69718.0 | NaN | NaN | NaN | NaN | N | NaN | 0.0 | ARCHIVE IMAGE ACCEPT | 5/26/20 | 5/27/20 | NaN | 5/3/20 | 14 | TCJ1 | 5/21/20 | WJSANANTONIOT050320_V01 | VCH | transcom.scott.tcj8.mbx.dts-rejects@mail.mil | NaN | 0.00 | N | N | WISTARIA JOSEPH | 0.0 | 0.0 | N | 0.0 | 5/26/20 | 387700^97^^X^4930^FD50^6F^0^70^AB^G041D0^^_12400^^^^40924^^^387700^^^48090D^^^^^ | 20 J1 MSPT | SAN ANTONIO,TX | 0.0 | 0.0 | 5/31/20 | 1.0 | Y | N | DJ60TCJ1 | 0.00 | 0.00 | 3NL75D | 0.0 | NaN | 0.0 | 5/20/20 | 0.0 | 0.0 | 2F41TY TD | NaN | 5/24/20 | NaN | N | *****6411 | N | 2F41TY | 0.0 | 659.2 | 18.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 4010.33 | 4010.33 | SAN ANTONIO,TX | wistaria.j.joseph.mil@mail.mil | WISTARIA | JOSEPH | PNR Locator:3NL75D | MISSION - OPERATIONAL | Temporary Duty Travel (Routine) | 0.0 | 0.0 |
| 9 | Y | 0.0 | N | 0.0 | 7700.30 | peggy.a.beahm.civ@mail.mil | 69719.0 | NaN | NaN | No | Okay | Y | NaN | 0.0 | ARCHIVE IMAGE ACCEPT | 5/20/20 | 5/21/20 | NaN | 3/16/20 | 15 | TCJ3 | 5/19/20 | ARLITTLEROCKA031620_V01 | VCH | transcom.scott.tcj8.mbx.dts-rejects@mail.mil | NaN | 7700.30 | N | N | ANDREW RODDAN | 0.0 | 0.0 | N | 0.0 | 5/20/20 | 387700^57^^0^3400^^30^^65^MD^330000^02^^^^^40924^^^387700^^^41132F^^^^^ | 20 GRP NON FLY1 | LITTLE ROCK AFB,AR | 0.0 | 0.0 | 5/31/20 | 1.0 | N | N | DJ60TCJ3 | 0.00 | 0.00 | NaN | 0.0 | NaN | 0.0 | 5/13/20 | 1.0 | 1.0 | 2EARVV TD | NaN | 5/20/20 | NaN | N | *****1749 | N | 2EARVV | 0.0 | 0.0 | 59.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 7700.30 | 7700.30 | LITTLE ROCK AFB,AR | andrew.l.roddan.mil@mail.mil | ANDREW | RODDAN | C-130J RequalCourse PXC2020X14 TLN: OD3T000003 | TRAINING | Temporary Duty Travel (Routine) | 0.0 | 0.0 |
Last rows
| Actuals(Y/N) | AdvanceAmount | AdvanceReject(Y/N) | Advisory | AmountClaim | AOEmailAddress | AutoKey | AwaitingStatus | CancelledDate | Changes_Needed_(Y/N) | Comments | ConstructiveTravelFlag | Corrected_Date | CorrectedVouchers | CurrentStatus | CurrentVersionCompletedDate | DateofCurrentStatus | DCSSuborganization | DepartureDate | df_index | Directorate | DocumentCreateDate | DocumentName | DocumentType | DTAIDEmailAddress | Error_Category | ExpensesbyLOA | FinancialReject(Y/N) | ForeignTravelFlag | FullName | ImproperPaymentCorrections | ImproperPayments | IncludesSPP(Y/N) | InputError | LastAOApprovedDate | LOA10by20 | LOALabel | Location/Destination(firstonly) | Miscellaneous | Missing_InvalidReceipt_Documentation | Month_End | Month_Rank | MultipleLOAs(Y/N) | Non-contractFareFlag | Organization/Suborganization | Overpayments(Debts)* | Overpayments_(Debts)* | PNRRecordLocator(allshown) | Receiptdoesnotmatchclaim | Reference | Regulation_Unauthorized | ReturnDate | Reviewed_Record | ReviewedVouchers | SDN(representativeSDNfordoctype) | Sent_Date | SignedDate | SpecialCircumstancesTripType | SPPReject(Y/N) | SSN | T-EnteredFlag | TANum | TotalCP-C/CR-CAmount | TotalCP/CRAmount | TotalDaysTDY | TotalInputError | TotalMiscellaneous | TotalMissingInvalidReceiptDocumentation | TotalReceiptDoesNotMatchClaim | TotalRegulationUnauthorized | TotalReimbursableExpenses | TotalTripExpenses | Travel_Location | TravelerEmailAddress | TravelerFirstName | TravelerLastName | TripDescription | TripPurpose | TripType | Underpayments(Credits)* | Underpayments_(Credits)* | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5489 | N | 0.0 | N | 0.0 | 6164.12 | jonathan.gilbert@jte.osd.mil | 63055.0 | NaN | NaN | NaN | NaN | N | NaN | 0.0 | ARCHIVE IMAGE ACCEPT | 6/6/19 | 6/8/19 | NaN | 5/6/19 | 7123 | TCSG | 5/24/19 | MHFRANKFURTAM050519_V01 | VCH | transcom.scott.tcj8.mbx.dts-rejects@mail.mil | NaN | 6164.12 | N | Y | MICHELE HOLDERNESS | 0.0 | 0.0 | N | 0.0 | 6/6/19 | 012148^097^^0460^^20182019^^^^0600030605814OTE^10156^340508^^16723446^10807^^3131^^^ | 18 DOTE JIMTM | FRANKFURT AM MAIN,DEU | 0.0 | 0.0 | 6/30/19 | 12.0 | N | Y | DJ60TCSG | 0.0 | 0.0 | 2JCV36 | 0.0 | NaN | 0.0 | 5/17/19 | 0.0 | 0.0 | 2AU999 | NaN | 6/5/19 | NaN | N | *****9116 | N | 2AU999 | 0.0 | 2153.14 | 12.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 6164.12 | 6164.12 | FRANKFURT AM MAIN,DEU | michele.j.holderness.mil@mail.mil | MICHELE | HOLDERNESS | JIMTM TPMRC Close downPNR Locator:2JCV36 | MISSION - OPERATIONAL | Temporary Duty Travel (Routine) | 0.0 | 0.0 |
| 5490 | Y | 0.0 | N | 0.0 | 786.25 | jonathan.gilbert@jte.osd.mil | 63056.0 | NaN | NaN | NaN | NaN | N | NaN | 0.0 | ARCHIVE IMAGE ACCEPT | 6/11/19 | 6/13/19 | NaN | 5/28/19 | 7124 | TCSG | 6/4/19 | MHSUFFOLKVA052819_V01 | VCH | transcom.scott.tcj8.mbx.dts-rejects@mail.mil | NaN | 786.25 | N | N | MICHELE HOLDERNESS | 0.0 | 0.0 | N | 0.0 | 6/11/19 | 012148^097^^0460^^20182019^^^^0600030605814OTE^10156^340508^^16723446^10807^^3131^^^ | 18 DOTE JIMTM | SUFFOLK,VA | 0.0 | 0.0 | 6/30/19 | 12.0 | N | N | DJ60TCSG | 0.0 | 0.0 | 3WJ9WP | 0.0 | NaN | 0.0 | 5/30/19 | 0.0 | 0.0 | 2B81T0 | NaN | 6/10/19 | NaN | N | *****9116 | N | 2B81T0 | 0.0 | 354.50 | 3.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 786.25 | 786.25 | SUFFOLK,VA | michele.j.holderness.mil@mail.mil | MICHELE | HOLDERNESS | JI-MTM DRB BoardPNR Locator:3WJ9WP | MISSION - OPERATIONAL | Temporary Duty Travel (Routine) | 0.0 | 0.0 |
| 5491 | N | 0.0 | N | 0.0 | 4706.63 | patrick.a.martinez4.mil@mail.mil | 63057.0 | NaN | NaN | NaN | NaN | N | NaN | 0.0 | POS ACK RECEIVED | 6/19/19 | 6/24/19 | NaN | 5/12/19 | 7125 | TCSG | 6/18/19 | MSBANGKOKTHA051119_V01-01 | VCH | transcom.scott.tcj8.mbx.dts-rejects@mail.mil | NaN | 4512.39 | N | Y | MARCUS SNYDER | 0.0 | 0.0 | N | 0.0 | 6/19/19 | 056521^17^19^19^1804^11CQ^2110^07411^^056521^2D^^N00038^J4^E2^VG^1A10^^^^6412^8522^AA^^^^^^ | 19 APRI 36412 | BANGKOK,THA | 0.0 | 0.0 | 6/30/19 | 12.0 | N | N | DJ60TCSG | 0.0 | 0.0 | NDONZ8 | 0.0 | NaN | 0.0 | 5/19/19 | 0.0 | 0.0 | N0003819TOATKDD | NaN | 6/18/19 | NaN | N | *****1604 | N | 2ATKDD | 0.0 | 2688.13 | 8.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 4512.39 | 4512.39 | BANGKOK,THA | MARCUS.SNYDER@us.af.mil | MARCUS | SNYDER | Nepal Subject Matter Expert ExchangePNR Locator:NDONZ8 | MISSION - OPERATIONAL | Temporary Duty Travel (Routine) | 0.0 | 0.0 |
| 5492 | N | 0.0 | N | 0.0 | 1666.60 | patrick.a.martinez4.mil@mail.mil | 63058.0 | NaN | NaN | NaN | NaN | N | NaN | 0.0 | ARCHIVE IMAGE ACCEPT | 6/25/19 | 6/26/19 | NaN | 3/3/19 | 7126 | TCSG | 4/30/19 | JAWASHINGTOND030419_V04-01 | VCH | transcom.scott.tcj8.mbx.dts-rejects@mail.mil | NaN | 1666.60 | N | N | JOHN ANDRUS | 0.0 | 0.0 | N | 0.0 | 6/25/19 | 387700^97^^X^4930^FD50^6F^9^70^AB^G00160^^_12400^^^^40924^^^387700^^^48090D^^^^^ | 19 SG HQ MSPT X | WASHINGTON,DC | 0.0 | 0.0 | 6/30/19 | 12.0 | N | N | DJ60TCSG | 0.0 | 0.0 | LRHNDY | 0.0 | NaN | 0.0 | 3/6/19 | 0.0 | 0.0 | 29OX2C TD | NaN | 6/25/19 | NaN | N | *****5797 | N | 29OX2C | 0.0 | 349.30 | 4.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 1666.60 | 1666.60 | WASHINGTON,DC | john.r.andrus.mil@mail.mil | JOHN | ANDRUS | PNR Locator:LRHNDY | SPEECH OR PRESENTATION | Temporary Duty Travel (Routine) | 0.0 | 0.0 |
| 5493 | N | 0.0 | N | 0.0 | 1217.93 | patrick.a.martinez4.mil@mail.mil | 63059.0 | NaN | NaN | NaN | NaN | N | NaN | 0.0 | ARCHIVE IMAGE ACCEPT | 6/25/19 | 6/27/19 | NaN | 5/19/19 | 7127 | TCSG | 6/3/19 | JARANDOLPHAFB051919_V02 | VCH | transcom.scott.tcj8.mbx.dts-rejects@mail.mil | NaN | 1217.93 | N | N | JOHN ANDRUS | 0.0 | 0.0 | N | 0.0 | 6/25/19 | 387700^97^^9^0130^1883^2X^9^65^BI^GH5980^01^^^^^40915^^^387700^^^87730F^^^^^ | 19 GPMRC TDY | RANDOLPH AFB,TX | 0.0 | 0.0 | 6/30/19 | 12.0 | N | N | DJ60TCSG | 0.0 | 0.0 | LVRIJF | 0.0 | NaN | 0.0 | 5/22/19 | 0.0 | 0.0 | 2B3KF5 TD | NaN | 6/25/19 | NaN | N | *****5797 | N | 2B3KF5 | 0.0 | 676.00 | 4.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 1217.93 | 1217.93 | RANDOLPH AFB,TX | john.r.andrus.mil@mail.mil | JOHN | ANDRUS | Air Force Medical Corps Development TeamPNR Locator:LVRIJF | MISSION - OPERATIONAL | Temporary Duty Travel (Routine) | 0.0 | 0.0 |
| 5494 | N | 0.0 | N | 0.0 | 2119.14 | patrick.a.martinez4.mil@mail.mil | 63060.0 | NaN | NaN | NaN | NaN | N | NaN | 0.0 | ARCHIVE IMAGE ACCEPT | 6/25/19 | 6/27/19 | NaN | 5/26/19 | 7128 | TCSG | 6/3/19 | JAKELLEYBARRA052719_V01 | VCH | transcom.scott.tcj8.mbx.dts-rejects@mail.mil | NaN | 2119.14 | N | Y | JOHN ANDRUS | 0.0 | 0.0 | N | 0.0 | 6/25/19 | 387700^97^^X^4930^FD50^6F^9^70^AB^G00160^^_12400^^^^40924^^^387700^^^48090D^^^^^ | 19 SG HQ MSPT X | KELLEY BARRACKS (STUTTGART),DEU | 0.0 | 0.0 | 6/30/19 | 12.0 | N | N | DJ60TCSG | 0.0 | 0.0 | 2NSZON | 0.0 | NaN | 0.0 | 5/31/19 | 0.0 | 0.0 | 2B83TM TD | NaN | 6/25/19 | NaN | N | *****5797 | N | 2B83TM | 0.0 | 1135.63 | 6.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 2119.14 | 2119.14 | KELLEY BARRACKS (STUTTGART),DEU | john.r.andrus.mil@mail.mil | JOHN | ANDRUS | COMMAND SURGEON SYNCHRONIZATION CONFERENCEPNR Locator:2NSZON | CONFERENCE- NON-TRAINING | Temporary Duty Travel (Routine) | 0.0 | 0.0 |
| 5495 | N | 0.0 | N | 0.0 | 1304.40 | Kerry.L.Mosley.MIL@MAIL.mil | 63061.0 | NaN | NaN | NaN | NaN | N | NaN | 0.0 | ARCHIVE IMAGE ACCEPT | 6/10/19 | 6/12/19 | NaN | 6/3/19 | 7129 | TCSG | 6/7/19 | SBFTBUCHANANI060319_V02 | VCH | transcom.scott.tcj8.mbx.dts-rejects@mail.mil | NaN | 1304.40 | N | N | STACEY BRANCH | 0.0 | 0.0 | N | 0.0 | 6/10/19 | 387700^97^^9^0130^1883^2X^9^65^BI^GH5980^01^^^^^40915^^^387700^^^87730F^^^^^ | 19 GPMRC TDY | FT. BUCHANAN [INCL GSA SVC CTR GUAYNABO],PR | 0.0 | 0.0 | 6/30/19 | 12.0 | N | N | DJ60TCSG | 0.0 | 0.0 | 3OC9FA | 0.0 | NaN | 0.0 | 6/6/19 | 0.0 | 0.0 | 2ASROA TD | NaN | 6/7/19 | NaN | N | *****1074 | N | 2ASROA | 0.0 | 496.40 | 4.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 1304.40 | 1304.40 | FT. BUCHANAN [INCL GSA SVC CTR GUAYNABO],PR | STACEY.L.BRANCH.mil@mail.mil | STACEY | BRANCH | 2019 TRICARE Latin America and Canada Senior Leaders and Stakeholders Engagement ForumPNR Locator:3OC9FA | MISSION - OPERATIONAL | Temporary Duty Travel (Routine) | 0.0 | 0.0 |
| 5496 | Y | 0.0 | N | 0.0 | 1493.42 | patrick.a.martinez4.mil@mail.mil | 63062.0 | NaN | NaN | NaN | NaN | N | NaN | 0.0 | ARCHIVE IMAGE ACCEPT | 6/5/19 | 6/8/19 | NaN | 5/27/19 | 7130 | TCSG | 6/4/19 | SKKELLEYBARRA052719_V01 | VCH | transcom.scott.tcj8.mbx.dts-rejects@mail.mil | NaN | 1493.42 | N | Y | SYLVIA KIM | 0.0 | 0.0 | N | 0.0 | 6/5/19 | 387700^97^^9^0130^1883^2X^9^65^BI^GH5980^01^^^^^40915^^^387700^^^87730F^^^^^ | 19 GPMRC TDY | KELLEY BARRACKS (STUTTGART),DEU | 0.0 | 0.0 | 6/30/19 | 12.0 | N | N | DJ60TCSG | 0.0 | 0.0 | NaN | 0.0 | NaN | 0.0 | 5/31/19 | 0.0 | 0.0 | 2B7MOC TD | NaN | 6/4/19 | NaN | N | *****1556 | N | 2B7MOC | 0.0 | 0.00 | 5.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 1493.42 | 1493.42 | KELLEY BARRACKS (STUTTGART),DEU | sylvia.kim@us.af.mil | SYLVIA | KIM | AFRICOM Surgeon General Synchronization Conference 2019 | CONFERENCE- NON-TRAINING | Temporary Duty Travel (Routine) | 0.0 | 0.0 |
| 5497 | N | 0.0 | N | 0.0 | 2582.96 | patrick.a.martinez4.mil@mail.mil | 63063.0 | NaN | NaN | Yes | Traveler claimed lodging 2X, once on the per diem screen as it should be and once on the Expense screen. Over paid $644. | N | 8/13/19 | 1.0 | ARCHIVE IMAGE ACCEPT | 6/21/19 | 6/25/19 | NaN | 5/19/19 | 7131 | TCSG | 6/17/19 | SSNEWORLEANSL051919_V01 | VCH | transcom.scott.tcj8.mbx.dts-rejects@mail.mil | NaN | 2582.96 | N | N | STEVEN SAVOY | 28.0 | 1.0 | N | 0.0 | 6/21/19 | 387700^97^^X^4930^FD50^6F^9^70^AB^G00160^^_12400^^^^40924^^^387700^^^48090D^^^^^ | 19 SG HQ MSPT X | NEW ORLEANS,LA | 0.0 | 0.0 | 6/30/19 | 12.0 | N | N | DJ60TCSG | 644.0 | 644.0 | NaN | 1.0 | NaN | 0.0 | 5/31/19 | 1.0 | 1.0 | 2B0PAL TD | 7/16/19 | 6/20/19 | NaN | N | *****7139 | N | 2B0PAL | 0.0 | 0.00 | 13.0 | 0.0 | 0.0 | 0.0 | 1.0 | 0.0 | 2582.96 | 2582.96 | NEW ORLEANS,LA | steven.r.savoy3.fm@mail.mil | Steven | Savoy | Site visits for PM for DSCA & State Gen Pop exercise | MISSION - OPERATIONAL | Temporary Duty Travel (Routine) | 0.0 | 0.0 |
| 5498 | Y | 0.0 | N | 0.0 | 1263.76 | patrick.a.martinez4.mil@mail.mil | 63064.0 | NaN | NaN | NaN | NaN | N | NaN | 0.0 | ARCHIVE IMAGE ACCEPT | 6/21/19 | 6/24/19 | NaN | 6/10/19 | 7132 | TCSG | 6/18/19 | SSSTCROIXVI061019_V01 | VCH | transcom.scott.tcj8.mbx.dts-rejects@mail.mil | NaN | 3221.11 | N | N | STEVEN SAVOY | 0.0 | 0.0 | N | 0.0 | 6/21/19 | 387700^97^^X^4930^FD50^6F^9^70^AB^G00160^^_12400^^^^40924^^^387700^^^48090D^^^^^ | 19 SG HQ MSPT X | ST. CROIX,VI | 0.0 | 0.0 | 6/30/19 | 12.0 | N | N | DJ60TCSG | 0.0 | 0.0 | MC8X58 | 0.0 | NaN | 0.0 | 6/13/19 | 0.0 | 0.0 | 2BH62X TD | NaN | 6/20/19 | NaN | N | *****7139 | N | 2BH62X | 1949.0 | 0.00 | 4.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 1263.76 | 3221.11 | ST. CROIX,VI | steven.r.savoy3.fm@mail.mil | Steven | Savoy | Site visits for DSCA support for 2019 Hurricane SeasonPNR Locator:MC8X58 | MISSION - OPERATIONAL | Temporary Duty Travel (Routine) | 0.0 | 0.0 |